Kbase P86773: How to get the number of field array elements from the database meta schema
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/09/2004 |
|
Status: Unverified
GOAL:
How to get database meta schema information of array fields
GOAL:
How to get the number of field array elements
FACT(s) (Environment):
Progress 9.1D
FIX:
Syntax for getting the tables belonging to the pub schema:
select * from sysprogress.systables where tbltype = 'T' and owner = 'PUB'
Syntax for getting the columns belonging to a specific table:
select * from sysprogress.syscolumns where tbl = '<table name>'
Example:
select * from sysprogress.syscolumns where tbl = 't_arr1'
Syntax for getting the number of elements a specific array field contains:
select "_Extent" from pub."_field" where "_field-Name" = '<column name>'
Example:
select "_Extent" from pub."_field" where "_field-Name" = 'f_arr1'