CHANGEABLE

CHAR(1)

No

Indicates whether a change is allowed.

COLUMN_DEFAULT

CHAR(1)

Yes

This column is null if the CA Datacom Datadictionary attribute DBEDITS is set to NO. Otherwise, the column contains:

D

Standard data type defaults.

O

A literal is the default value.

N

No default which indicates that the field must be provided during every insert.

S

Security accessor ID is the default value.

U

The SQL AUTHID is the default value.

COLUMN_LENGTH

INTEGER

No

The length of the column as it is stored in the CA Datacom/DB row. This includes 1 byte if the column can be null plus 2 bytes if the column is variable-length.

COLUMN_OFFSET

INTEGER

No

The displacement or offset of this column from the start of the row.

COLUMN_SEQ

SMALLINT

No

Sequence number of this column within the columns of the row. The first physical column in the row (which is nullable or has DBEDITS) has a sequence number of 1, the second 2, and so on.

COLUMN_SIGN

CHAR(1)

Yes

This column is null if the field is not one of the numeric data types. Otherwise, this column specifies whether this column was defined as signed numeric.

COLUMN_TYPE

CHAR(1)

Yes

Column type is null if the CA Datacom Datadictionary DBEDITS attribute is set to NO. Otherwise, this field represents the CA Datacom Datadictionary field type.

N

Numeric

D

Decimal

L

Long float

S

Short float

E

Extended float

B

Binary

W

Variable graphics

G

DBCS

C

Character

V

Variable character

COLUMN_VALUE_CHAR

CHAR(20)

Yes

This field is null if the column did not have the CA Datacom Datadictionary DBEDITS attribute set YES or the default to be other than literal. Otherwise, this is the character form of the data placed in the column. For variable-length fields the first two positions is the length of the following data moved to the field.

COLUMN_VALUE_LEN

SMALLINT

Yes

This field is null if the column did not have the CA Datacom Datadictionary DBEDITS attribute set YES or the default to be other than literal. Otherwise, this is the length of the literal that is placed in the column. If this is a variable character column, then this length includes 2 bytes for the length of the data.

DBEDITS

CHAR(1)

No

Indicates whether the field was defined with the CA Datacom Datadictionary DBEDITS attribute on or off.

DBID

SMALLINT

No

The database identifier of the database containing the table containing this column.

DIR_NAME

CHAR(8)

No

Name of the Directory that the MUF is using.

FORCE_ADD

CHAR(1)

No

Indicates whether CA Datacom/DB is to force new data to this field when inserting a row.

FORCE_UPDATE

CHAR(1)

No

Indicates whether CA Datacom/DB is to force new data to this field when updating a row.

NULLABLE

CHAR(1)

No

Indicates whether the column can be set to NULL.

OCCURRENCE

CHAR(32)

No

Contains the CA Datacom Datadictionary entity occurrence name of this column.

SEMANTIC_TYPE

CHAR(8)

Yes

Set to NULL if this column was not defined to CA Datacom Datadictionary with the DBEDITS set to YES or if the column has no semantic data type. Otherwise, it can contain one of the following:

DATE

SQL type date

TIME

SQL type time

TIMESTMP

SQL type timestamp

MIXED

Mixed case data

BIT-DATA

For-bit-data

SQL_TYPE

CHAR(8)

Yes

Set to NULL if this column was not defined to CA Datacom Datadictionary with the DBEDITS set to YES or if this column cannot be represented by a data type recognized by SQL. Otherwise, it can contain one of the following:

NUMERIC

Zone decimal (signed or unsigned)

DECIMAL

Packed decimal (signed or unsigned)

FLOAT

Floating-point numbers

SQL-DATE

SQL DATE

SQL-TIME

SQL TIME

SQL-STMP

SQL TIMESTAMP

SMALLINT

2-byte binary signed number

INTEGER

4-byte binary signed number

CHAR

Character field

VARCHAR

Variable character field

VARG

Variable graphics field

GRAPHIC

Graphics field

STATUS

CHAR(1)

No

Status of the CA Datacom Datadictionary occurrence name for this column.

TABLE_NAME

CHAR(3)

No

Contains the DATACOM-NAME attribute-value of the table containing this column.

VERSION

SMALLINT

No

Version of the CA Datacom Datadictionary occurrence name for this column.