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) |