OWNER

CHAR(32)

Name of the owner of the database object

TABLENAME

CHAR(32)

Name of the database object

COLUMNNAME

CHAR(32)

Name of the column

MODE

CHAR(3)

Type of column (KEY | MAN | OPT)

DATATYPE

CHAR(10)

Data type of the column (BOOLEAN | CHAR | DATE | FIXED | FLOAT | INTEGER | LONG | SMALLINT | TIME | TIMESTAMP)

CODETYPE

CHAR(8)

Code attribute of the column (ASCII | EBCDIC | BYTE | UNICODE)

LEN

FIXED(4)

Length or precision of the column

DEC

FIXED(3)

Number of decimal places in the columns of data type FIXED

NULLABLE

CHAR(3)

Column can accept the null value (YES/NO)

COLUMNPRIVILEGES

CHAR(8)

Privileges of the current user for the column

DEFAULT

CHAR(254)

DEFAULT value for the column

DOMAINOWNER

CHAR(32)

Name of the owner of the domain

DOMAINNAME

CHAR(32)

Name of the domain

POS

FIXED(4)

Original position of the column in the table

KEYPOS

FIXED(4)

Original position of the key column in the table

CREATEDATE

DATE(10)

Creation date of the column

CREATETIME

TIME(8)

Creation time of the column

ALTERDATE

DATE(10)

Alter date of the column

ALTERTIME

TIME(8)

Alter date of the column

TABLETYPE

CHAR(8)

Table type (SYSTEMS | TABLES)

COMMENT

LONG

Comment on the column