Previous Topic: DB2_MVS_INDEXSPCNext Topic: DB2_MVS_TABLESPC


DB2_MVS_TABLE

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

Col

Column Name

Len

Coltype

Description

1

ID

4

INTEGER

ID of DB2 tabel

2

MODEL_ID

4

INTEGER

ID of the containing model

3

TBNAME

16

CHAR

DB2_MVS_TABLE

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

CHAR

Name

6

RI_TRIG_PRFX

32

CHAR

RI trigger and procedure name prefix

7

OWNER_ID_EXT

8

CHAR

Owner identifier extension

8

PV_READ_ENF

1

CHAR

Permitted value READ enforcement

9

PV_DBMS_ENF

1

CHAR

Permitted value DBMS enforcement

10

RSTR_DROP

1

CHAR

With restrict on drop?

11

DATA_CAPTURE

1

CHAR

Data capture?

12

RECORD_ID

4

INTEGER

Base record this object is extended from. Join with RECORD.