Previous Topic: DB2_DDL_DBNext Topic: DB2_DDL_TABLE


DB2_DDL_INDEX

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_INDEX

3

ID

4

CHAR

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

MEMBER_NAME

8

CHAR

Name of member containing generated DDL for DB2 index 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

ENTRY_POINT_ID

4

INTEGER

ID of the entry point which this DB2 index definition is built from.

Join with ENTRY_POINT.