SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-55
Considerations—DISPLAY USE OF
DISPLAY USE OF lists only registered SQL programs. Unregistered SQL
programs cannot be listed because neither such programs nor their dependency
relationships are described in catalogs.
The types of objects that can depend on each type of object are:

The USAGES catalog table contains descriptions of the relations among primary
partitions only. The only exception to this rule is that the USAGES table describes
a relation between each partition of a protection view and the corresponding
partition of the table that the protection view depends on. If an object depends on a
protection view, however, the USAGES table describes only the relation between
the primary partitions of the dependent object and the protection view.
If object is the name of a secondary partition, DISPLAY USE OF substitutes the
name of the primary partition and reports the primary partitions of all the objects
that depend on that primary partition.

The columns of the DISPLAY USE OF output contain these information:

Object Name
The name of the object or one of its dependent objects or programs, preceded
by an integer level number. (The original object is at level 0, objects directly
dependent on the original object are at level 1, and so forth.)
All names of dependent objects appear as fully qualified Guardian names. For
an SQL program in an OSS file, the fully qualified Guardian name is the ZYQ
name of the program file, and a pathname for the file appears immediately
below the ZYQ name, wrapping over multiple lines if necessary. (If no
pathname for the file is accessible to the user, the message “No pathname
accessible.” appears instead.)

Type
A two-character code that specifies the object type:
Objects Dependent Objects
Table Indexes, protection views, shorthand views,
SQL programs
Protection view Shorthand views, SQL programs
Shorthand view Shorthand views, SQL programs
Index SQL object programs
Collation Indexes, protection views, shorthand views,
SQL programs, tables
CP Collation
IN Index
PG SQL program