Previous Topic: REC_ENTRY_PT_USENext Topic: RECORD_REFERENCE


RECORD

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

Col

Column Name

Len

Coltype

Description

1

ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

RECORD

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Record name

6

MACRO_NAME

32

VARCHAR

Macro name

7

EDITPROC_NAME

8

CHAR

Edit proc routine name

8

VALIDPROC_NAME

8

CHAR

Validation proc routine name

9

OWNER_NAME

8

CHAR

DB2 owner identifier

10

DB2_SYNONYM

8

CHAR

DB2 synonym for table

11

ROLE

1

CHAR

Role:

D (Data record)

L (Link record)

12

DBMS

1

CHAR

Database management system:

2 (DB2)

1 (DL/1)

13

TYPE

1

CHAR

Record type:

P (Physical)

L (Logical)

V (Virtual)

14

DATA_STORE_ID

4

INTEGER

ID of the containing data store. Join with DATA_STORE_TBLSP.