Rocket® Enterprise Developer (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
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) |