Previous Topic: Access and Connection ObjectsNext Topic: ENTRY_POINT


Design Tasks Related to Access and Connection Objects

The following table directs you to the PI table explanation that contains SQL for Design tasks related to database access and connection objects:

If You Want To

See

Select the entry points defined for record

REC_ENTRY_PT_USE

Select the entry points used for each entry point implementation technique, the record on which the entry point is defined, and the foreign key fields and their usage in the entry point

Entry Point Technique

Select the fields that participate in an index

FLD_ENTRY_PT_USE

Select all the limit values for a partitioned entry point.

FLD_ENTPT_VALUE

Select all the limit values for a partitioned indexspace dataset.

FLD_ENTPT_VALUE

Select the foreign keys in the from record and the corresponding target field of the to record

Foreign Key Technique

Select the foreign key fields in the link record and the corresponding target field of the to record

Many-to-Many Technique

Select the field that a foreign key is pointing to

FLD_LINK_USE