NAME

Column name.

CHAR(32)

NOT NULL

NUMBER

Relative number of the column within the table.

SMALLINT

NOT NULL

SCHEMA

Schema-name qualifier of the table or view that contains the column.

CHAR(18)

NOT NULL

TABLE

Name of the table or view that contains the column.

CHAR(18)

NOT NULL

TYPE

Column data type in character format.

CHAR(18)

NOT NULL

TYPECODE

Column data type in numeric format. For a description of values in this field, see SQLTYPE

SMALLINT

NOT NULL

PRECISION

Precision of numeric columns.

SMALLINT

NOT NULL

SCALE

Scale of exact numeric fields or code indicating the type of date/time column. For a description of values in this field, see SQLSCALE.

SMALLINT

NOT NULL

NULLS

Nulls allowed:

• N—No
• Y—Yes

CHAR(1)

NOT NULL

DEFAULT

Default value stored:

• N—No
• Y—Yes

VOFFSET

Offset to column value within a row.

SMALLINT

NOT NULL

VLENGTH

Length of column value.

SMALLINT

NOT NULL

NOFFSET

Offset to NULL indicator for the column a row.

SMALLINT

NOT NULL

NLENGTH

Length of NULL indicator.

SMALLINT

NOT NULL

NUMVALUES

If the column is the first column in an index key, the number of unique values in the column when statistics were last updated.

INTEGER

NOT NULL

SECLOWVAL

If the column is the first column in an index key, the first eight bytes of the second lowest column value when statistics were last updated.

BINARY(8)

NOT NULL

SECHIGHVAL

If the column is the first column in an index key, the first eight bytes of the second highest column value when statistics were last updated.

BINARY(8)

NOT NULL

PROCPARMTYPE

Procedure parameter mode:

• I—Input parameter
• O—Output parameter
• B—Both Input and Output

CHAR(1)

NOT NULL

FILLER

Reserved for future use.

BINARY(39)

NOT NULL