1

ID

4

INTEGER

ID of DB2 column

2

MODEL_ID

4

INTEGER

ID of the containing model

3

TBNAME

16

CHAR

DB2_MVS_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

DFLT_VALUE_
SPEC

1

CHAR

Default value specified

11

FIELD_ID

1

INTEGER

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