Qualifier1

Creator/Schema name.

Qualifier2

PowerExchange data map name will be returned, or null for NRDB2.

Tablename

Return table name.

Column_name

Column name.

Type

Field format.

Precision

Field length.

Scale

Decimal places.

Nullable

Nullable.

Detail_type

Internal column type representation.

Comments

Comments column always present. Comment information is included only if requested by specifying the comments indicator in the describe.

Key_type

Reserved for future use.

Ref_qualifier_1

Reserved for future use.

Ref_qualifier_2

Reserved for future use

Ref_table_name

Reserved for future use

Ref_column_name

Reserved for future use

Base Record

Describes the dependencies for a table. For example,

ROOT(SEG2(SEG3,SEG4),SEG5).

Base Field

Column base field, such as

ROOT:ROOTKEY

.

Base Field Type

Field type of the column's base field (CHAR, VARCHAR etc.).

Base Field Offset

Returns the offsets of the field within the record. There is a case when no offset is returned. If you have an array of fields and you collapse the array when you generate the table the offset of those fields will be 0.

Field Usage

Usage of field. For example, COMP or DISPLAY for Cobol.

Field Level

Indent level of the field in the Cobol copybook.

Original Field Name

Original name of the field as given in the Cobol copybook.

Field Picture

Cobol picture format of the field.

CCSID

CCSID.

Internal_cp

Internal code page.

Codepage_name

Code page name.

Powercenter_name

PowerCenter name of the code page.