Previous Topic: FLD_ENTPT_VAL_I (Field Entry Point Value)Next Topic: FLD_ENTRY_PT_USE (Field Entry Point Usage)


FLD_ENTPT_VALUE (Field Entry Point Value)

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

FLD_ENTPT_VALUE

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

SEQ

NUMERIC

Sequence within field entry point usage.

Use ORDER BY SEQ to return the values in the same order as specified in the toolset.

SEQT

NUMERIC

Sequence within tablespace data set.

Use ORDER BY SEQT to return the values in the same order as specified in the toolset.

SEQI

NUMERIC

Sequence within indexspace data set.

Use ORDER BY SEQI to return the values in the same order as specified in the toolset.

FLD_ENTPT_US_ID

NUMERIC

ID of the field entry point usage that controls this partition.

Join with FLD_ENTRY_PT_USE.

DATASET_TBSP_ID

NUMERIC

ID of the tablespace data set that this value determines the partitioning for.

Join DATASET_TBLSP.

DATASET_INDX_ID

NUMERIC

ID of the indexspace data set that this value determines the partitioning for.

Join with DATASET_INDEX.

VALUE

VARYING LENGTH STRING

Partitioning limit value