Previous Topic: DATASET_TBLSPNext Topic: DB2_DDL_INDEX


DB2_DDL_DB

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

Col

Column Name

Len

Coltype

Description

1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

DB2_DDL_DB

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

MEMBER_NAME

8

CHAR

Name of member containing generated DDL for DB2 database definition

6

DATE_GENERATED

4

INTEGER

Generation date

7

TIME_GENERATED

4

INTEGER

Generation time

8

GEN_BY_USER

8

CHAR

Generated by user ID

9

DATA_BASE_ID

4

INTEGER

ID of the database with which this DB2 database definition is built.

Join with DATA_BASE.