AREA_NAME

CHAR(3)

No

The short name (DATACOM-NAME attribute-value) of the area containing the table.

ANY_AUTHID

CHAR(32)

Yes

If this is a partition, this is the Any Parent SQL AUTHID.

ANY_SQLNAME

CHAR(32)

Yes

If this is a partition, this is the Any Parent SQL name.

ANY_TABLE

CHAR(3)

Yes

If this is a partition, this is the Any Parent name.

CHILD_RESTRICTED

CHAR(1)

Yes

If this table is partitioned, this column indicates whether users can access the Child table directly, Y or N. If this table is not partitioned, this column is null.

CHNG_MASTER_KEY

CHAR(1)

No

Indicates whether the Master Key can be changed during update processing.

CLUSTER_KEY_ID

SMALLINT

No

Specifies the Cluster Key ID. (If clustering by table, the Cluster Key is 0.)

CLUSTER_KEY_LEN

SMALLINT

No

Specifies the Cluster Key length for the table. (If clustering is by table, the Cluster Key length is 3.)

COMPRESS_EXIT

CHAR(8)

No

Name of the user compression routine. Blanks if no user compression for this table.

COMPRESSION

CHAR(1)

No

Indicates whether CA Datacom/DB compression is active in the table.

CURR_CONSTRAINT_ER

CHAR(1)

No

Indicates whether this table currently has a constraint error.

CURR_FWD_RCV_PEND

CHAR(1)

No

Indicates whether this table currently is in check pending status due to a forward recovery utility execution.

CURR_LOAD_PEND

CHAR(1)

No

Indicates whether this table currently is in check pending status due to a load utility execution.

CURR_RELATED_PEND

CHAR(1)

No

Indicates whether this table currently is in a check pending status due to a related table being in check pending status.

DBID

SMALLINT

No

Specifies the database identifier of the database containing this table.

DD_DBID

SMALLINT

No

Contains the database identifier of the CA Datacom Datadictionary that last cataloged this definition to the Directory (CXX). The field can be zeros for bases built during a CXX load.

DEFINITION_POSTED

CHAR(1)

No

Contains a C if the definition was last posted to the Directory (CXX) with a CA Datacom Datadictionary CATALOG or an SQL CREATE TABLE. Contains a D if the definition was last posted to the CXX with a DBUTLTY CXXMAINT OPTION=DDPROD. Contains a blank if the definition was last posted to the Directory (CXX) with a DBUTLTY LOAD function.

DIR_NAME

CHAR(8)

No

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

DL1T_CONSTRAINT

CHAR(1)

No

Indicates that CA Datacom DL1 Transparency constraints are in effect for this table. See the CA Datacom DL1 Transparency User Guide for more information.

DOMAIN_CONSTRAINT

CHAR(1)

No

Indicates that CA Datacom/DB domain constraints are in effect for this table.

DUP_MASTER_KEY

CHAR(1)

No

Indicates whether duplicate Master Key values are allowed.

ENCRYPTION_KEY

CHAR(8)

No

Encryption key provided through CA Datacom Datadictionary for the table when using user compression with the CA Datacom Presspack feature.

ENCRYPTION_METHOD

CHAR(1)

No

Indicates the method of encryption to use. Contains one of the following:

- Blank - No encryption

- A - AES-128
- B - AES-191
- C - AES-256

ENCRYPTION_TYPE

CHAR(1)

No

Indicates the type of encryption to use. Contains one of the following:

- Blank - No encryption

- B - Basic encryption performed by CA Datacom/DB with no key management

FULL_AUTHID

CHAR(32)

Yes

If this is a partition, this is the Full Parent SQL AUTHID.

FULL_SQLNAME

CHAR(32)

Yes

If this is a partition, this is the Full Parent SQL name.

FULL_TABLE

CHAR(3)

Yes

If this is a partition, this is the Full Parent name.

GENERATION

SMALLINT

No

Value returned is 1 for generation 1.

HIST_CONSTRAINT_ER

CHAR(1)

No

Indicates whether data in the row or rows violated an integrity constraint or constraints, but was confirmed with the force option.

HIST_FORCED_OFF

CHAR(1)

No

Indicates whether a constraint condition was forced off.

HIST_FWD_RCV_PEND

CHAR(1)

No

Indicates whether the table was in check pending status due to forward recovery when the table was confirmed with the force option.

HIST_LOAD_PEND

CHAR(1)

No

Indicates whether the table was in check pending status due to a LOAD utility when the table was confirmed with the force option.

HIST_RELATED_PEND

CHAR(1)

No

Indicates whether the table was in check pending status due to a related table when this table was confirmed with the force option.

INDEX_LOADED

CHAR(1)

No

Indicates whether the Index is loaded for data in this area.

KEY_ELEMENT_LENGTH

INTEGER

No

Number of bytes of memory that is required to contain this tables key, element and any column information.

LOGOPTION

CHAR(1)

No

Indicates whether logging is active for the table.

MOVE_TO_NEW_PART

CHAR(1)

Yes

If this table is partitioned, this column indicates whether an update is allowed to move a row to a different partition, Y or N. If this table is not partitioned, this column is null.

NEW_DBID

CHAR(1)

No

Indicates whether the DBID was changed using the NEWDBID option during a LOAD AREA=CXX or CXXMAINT OPTION=DDPROD utility.

OCCURRENCE

CHAR(32)

No

CA Datacom Datadictionary occurrence name for this table.

PARTITION_TABLE

CHAR(1)

No

Contains a Y if this table is a partition, or contains an N if this table is not a partition.

PIPELINE

CHAR(1)

No

Indicates whether the pipeline maintenance option is active for this table.

RECORDS

INTEGER

No

Number of records in table. If a system failure has occurred during add/delete processing, this number can be inaccurate.

RECORD_LENGTH

INTEGER

No

The length of the user data. Does not include the CA Datacom/DB Record Control Element (RCE) of 12 (or 4) bytes.

RECOVERY

CHAR(1)

No

Indicates whether the recovery option is activated for this table.

REFERENCES_IN_BASE

CHAR(1)

Yes

Is set to null if the table is not defined with referential integrity to another table. If the table is referenced or referencing, then this field indicates if all relationships to this table exist in this same database.

SQL_AUTHID

CHAR(32)

No

Contains the SQL AUTHID (authorization ID) of this table. Contains blanks if the table has no SQL access.

SQL_INTENT

CHAR(1)

No

Specifies the status of the SQL:

• Y - if the table has been defined with full SQL access
• R - if the table is SQL read-only
• N - if no SQL access is allowed
• * (asterisk) - if unknown because the structure was cataloged before the SQL INTENT option was supported.

STATUS

CHAR(1)

No

Specifies the status of the CA Datacom Datadictionary occurrence which defined this table.

TABLE_CONSTRAINED

CHAR(1)

No

Indicates whether SQL has constrained this table.

TABLE_ID

SMALLINT

No

Internal table identifier for this table.

TABLE_LOADED

CHAR(1)

No

Indicates whether the table is loaded.

TABLE_NAME

CHAR(3)

No

Contains the DATACOM-NAME attribute-value of the table.

TABLE_REFERENCED

CHAR(1)

No

Indicates whether the table references another table (is the subject of a relationship with another table).

TABLE_REFERENCING

CHAR(1)

No

Indicates whether the table is referenced by another table (the object of a relationship with another table).

TABLE_SQLNAME

CHAR(32)

No

The SQL name for this table if it is SQL accessible. It contains blanks if the table is not SQL accessible.

TABLE_TRIGGER

CHAR(1)

No

Indicates whether the table has one or more SQL triggers.

VERSION

SMALLINT

No

The version of the CA Datacom Datadictionary occurrence defining this table.