COLUMN_LENGTH

INTEGER

No

Contains the column length being used. It is the entire field as stored in the data row.

COLUMN_OFFSET

INTEGER

No

Contains the column offset into the row, starting from zero.

COLUMN_SEQ

SMALLINT

No

Contains the column sequence within partitioning columns.

DATA_FORMAT

CHAR(2)

No

Contains the format of the data, where:

CH

Indicates character.

DT

Indicates an SQL DATE.

TM

Indicates an SQL TIME.

TS

Indicates an SQL TIMESTAMP.

NM

Indicates numeric.

DBID

SMALLINT

No

Indicates the database ID containing the partitioned table.

DIR_NAME

CHAR(8)

No

Name of the Directory (CXX) used by this MUF.

FULL_TABLE

CHAR(3)

No

Provides the table name of the full table.

HIGH_LENGTH

SMALLINT

No

Contains the length of the highest value to reside in this partition. A length of zeros indicates the concept of high-value. Must match COLUMN_LENGTH when not character. If character, this is the length used to compare, such as a 100 byte-character column, but only the first 25 bytes are compared.

HIGHEST_VALUE

CHAR(60)

Yes

Contains a character representation of the highest value to reside in this partition when the format is not character. When it is character, this contains the actual high value and so might not be printable as is. Character data is left justified. Numeric data is right-justified. If numeric data is signed, the rightmost position contains a minus sign for negative or a blank for positive.

OCCURRENCE

CHAR(32)

No

Contains the CA Datacom Datadictionary occurrence name for the field.

PARTITIONS

SMALLINT

No

Contains the number of partitions for this Parent table.

TABLE_NAME

CHAR(3)

No

Contains the table name of the partition.

TABLE_NEXT

CHAR(3)

No

Contains the table name of the next partition of this Parent table, in data value order.

TABLE_ORDER

SMALLINT

No

Indicates the table order within partitions. Specifies that this is the first partition, or the second, and so on.

TABLE_PREV

CHAR(3)

No

Contains the table name of the previous partition of this Parent table, in data value order.