DBID

SMALLINT

No

Identifies the database containing this key field.

DIR_NAME

CHAR(8)

No

Name of the Directory used by this MUF.

FIELD_DECIMAL

CHAR(1)

No

Indicates whether this field is Packed Decimal type sensitive.

FIELD_FLOAT

CHAR(1)

No

Indicates whether this field is FLOAT data type sensitive.

FIELD_LENGTH

SMALLINT

No

Contains the length of this key field.

FIELD_NULLABLE

CHAR(1)

No

Indicates whether this field can be null.

FIELD_NUMERIC

CHAR(1)

No

Indicates whether this field is numeric (zoned decimal) data type sensitive.

FIELD_OFFSET

INTEGER

No

Offset or displacement from the start of the row to the start of this field.

FIELD_ORDER

CHAR(1)

No

Order of the field with either an A for ascending or a D for descending.

FIELD_SIGN_INT

CHAR(1)

No

Indicates whether this field is a signed integer (binary number) data type sensitive.

FIELD_UNIQUE

INTEGER

No

Number of rows indexed to be unique assuming all fields of this key are from the left through this key field. This field can be zero for a new table or key. The value is set during the LOAD, RETIX (not if KEYNAME=*DATA), or REPORT ...TYPE=G,UPDATE=YES.

KEY_FIELD_SEQ

SMALLINT

No

Sequence number (1—n) of this field within this key definition.

KEY_NAME

CHAR(5)

No

The short name (DATACOM-NAME attribute-value) of the key containing this field.

OCCURRENCE

CHAR(32)

No

Contains the CA Datacom Datadictionary entity-occurrence name for this field.

STATUS

CHAR(1)

No

Contains the CA Datacom Datadictionary status of this field.

TABLE_NAME

CHAR(3)

No

Contains the short name (DATACOM-NAME attribute-value) of the table containing key field.

VERSION

SMALLINT

No

Contains the version of the CA Datacom Datadictionary entity-occurrence for this key field.