Previous Topic: DIR_DIRECTORY (DRD)Next Topic: DIR_INDEX (DRI)


DIR_ELEMENT (DRE)

One record exists in this table for every element in the Directory. Each record includes information that exists for that specific element.

Column Name

SQL Data Type

Nullable

Description

DBID

 

SMALLINT

No

Identifies the database containing this element.

DIR_NAME

 

CHAR(8)

No

Name of the Directory used by the MUF.

ELEMENT_LENGTH

 

INTEGER

No

Contains the length of the element.

ELEMENT_NAME

 

CHAR(5)

No

Contains the short name (DATACOM-NAME attribute-value) assigned to the element.

ELEMENT_OFFSET

 

INTEGER

No

Contains the offset or displacement from the start of the row to the start of this element.

OCCURRENCE

 

CHAR(32)

No

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

SECURITY_CODE

 

SMALLINT

No

The element security code in numeric form.

STATUS

 

CHAR(1)

No

Status of the CA Datacom Datadictionary entity-occurrence for this element.

TABLE_NAME

 

CHAR(3)

No

Contains the DATACOM-NAME of the table containing this element.

VERSION

 

SMALLINT

No

Version of the CA Datacom Datadictionary entity-occurrence for this element.