SYSIBM.SYSCOLUMNS
SYSIBM.SYSCOLUMNS table
Column name
NAME TBNAME TBCREATOR COLNO
COLTYPE
Data type
VARCHAR(18) NOT NULL
VARCHAR(18) NOT NULL
CHAR(8) NOT NULL
SMALLINT NOT NULL
CHAR(8) NOT NULL
Description Use
Name of the column. G
Name of the table or view which contains the column. G
Authorization ID of the owner of the table or view that contains the G column.
Numeric place of the column in the table or view; for example 4 G (out of 10). An additional row with column number 0 is inserted
into SYSCOLUMNS if the definition of the table is incomplete (all required unique indexes have not been created).
The type of the column specified in the definition of the column: G
Contains one row for every column of each table and view.
1012 SQL Reference
INTEGER SMALLINT FLOAT CHAR VARCHAR LONGVAR DECIMAL GRAPHIC VARG LONGVARG DATE
TIME TIMESTMP BLOB CLOB DBCLOB ROWID DISTINCT
Large integer
Small integer
Floating-point
Fixed-length character string Varying-length character string Varying-length character string Decimal
Fixed-length graphic string Varying-length graphic string Varying-length graphic string Date
Time
Timestamp
Binary large object
Character large object Double-byte character large object Row ID data type
Distinct type
Whether a column described as VARCHAR, LONGVAR, VARG, or LONGVARG is a long string column depends on its length attribute. A column described as BLOB, CLOB, or DBCLOB is always a long string column.