Previous Topic Next topic Print topic


QUERY ODBC - Column Query

The results set for a column query is:

TABLE_QUALIFIER VARCHAR(128)  
TABLE_OWNER VARCHAR(128)  
TABLE_NAME VARCHAR(128) NOT NULL  
COLUMN_NAME VARCHAR(128) NOT NULL  
DATA_TYPE SMALLINT NOT NULL See odbcext.cpy and odbc.cpy for constants representing the ODBC data type codes.
TYPE_NAME VARCHAR(128) NOT NULL Driver dependent name for the column's data type.
PRECISION INTEGER  
LENGTH INTEGER Amount of memory required for a column value in its native representation.
SCALE SMALLINT  
RADIX SMALLINT For numeric columns either 10 or 2 depending on the data type; otherwise null
NULLABLE SMALLINT NOT NULL  
REMARKS VARCHAR(254)  
Previous Topic Next topic Print topic