Previous Topic: DB2_DDL_DB_INext Topic: DB2_DDL_INDEX_I


DB2_DDL_INDEX

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

DB2_DDL_INDEX

ID

STRING

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

MEMBER_NAME

STRING

Name of member containing generated DDL for DB2 index definition

DATE_GENERATED

NUMERIC

Generation date

TIME GENERATED

NUMERIC

Generation time

GEN_BY_USER

STRING

Generated by user ID

ENTRY_POINT_ID

NUMERIC

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

Join with ENTRY_POINT.