Previous Topic: DATA_STORE_TBLSPNext Topic: DATACOM_CONSTRNT


DATACOM_COLUMN

The following table details various column names along with their descriptions.

Note: DATACOM is no longer supported. This view will exist for compatibility reasons.

Col

Column Name

Len

Coltype

Description

1

MODEL_ID

4

INTEGER

ID of the containing model

2

ID

4

INTEGER

ID of Datacom column

3

TBNAME

16

CHAR

DATACOM_COLUMN

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

CHAR

Name

6

FORMAT

1

CHAR

Format of data

7

LENGTH

4

INTEGER

Length of field

8

NUM_DEC_PLC

4

INTEGER

Number of decimal places

9

OPTIONALITY

1

CHAR

Optionality for DBMS fields

10

DFTL_VALUE_SPEC

1

CHAR

Default value specified

11

FIELD_ID

1

INTEGER

Base column this object is extended from. Join with FIELD.