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 |
|
Copyright © 2013 CA.
All rights reserved.
|
|