Data Definition Language (DDL) Reference Manual

Dictionary-Manipulation Statements
Data Definition Language (DDL) Reference Manual—529431-004
8-12
SHOW USE OF
The SHOW USE OF listing includes a number to indicate the nesting level of the
objects it displays. Any objects that refer directly to a specified object are at nesting
level 1; any objects that refer directly to an object at level 1 are at nesting level 2; and
so forth.
If more than one object refers to a specified object, the listing is sequenced first by the
order in which objects are specified in the SHOW USE OF statement, second by the
order in which referring objects are in the dictionary, and third by the nesting level.
For the definitions in Example 8-12 on page 8-12 and Example 8-13 on page 8-13, see
the sample schema in Appendix B, Sample Schemas.
Example 8-12. SHOW USE OF Nesting Levels
!?DICT
Open dictionary.
!SHOW USE OF DEF zip-cd
Display objects that refer to the definition zip-cd (for
the definition of zip-cd and the objects that refer to it,
see the sample schema in Appendix B, Sample
Schemas).
(1) Definition ZIP-CD
(2) Definition ADDR
(3) Definition CUSTINFO
(2) Definition ADDR
(3) Definition SUPPINFO
used by Definition ADDR
used by Definition CUSTINFO
used by Record CUSTOMER
used by Definition SUPPINFO
used by Record SUPPLIER
Nesting levels for ZIP-CD:
ZIP-CD
ADDR
CUSTINFO SUPPINFO
CUSTOMER SUPPLIER
(1)
(2)
(3)
VST811.vsd