SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-54
DISPLAY USE OF Command
DISPLAY USE OF Command
DISPLAY USE OF is an SQLCI utility command that displays a list of SQL objects and
registered SQL object programs depend on the object specified.
object
is the name (or an equivalent DEFINE) of a collation, index, table, or view for which
to specify the dependent objects.
If object is a secondary partition, you must include either its node or the node
that contains the primary partition in the nodes you specify in the AT clause.
If SMF is installed on your node, object cannot specify any object on a $*.ZYS*.
subvolume.
AT { \node }
{ ( \node [, \node ] ... ) }
specifies nodes to search for dependent objects and programs. The default is all
nodes in the network.
{ BRIEF | STANDARD }
specifies the information and the format for display.
The default is STANDARD.
Considerations—DISPLAY USE OF

DISPLAY USE OF requires authority to read the catalogs that describe the object
you specify and the catalogs that describe all its dependent objects and programs.

DISPLAY USE OF searches the USAGES table in the catalog that describes
object to find the names of objects or programs that depend on object, then
searches the catalogs that describe the dependent objects and finds the names of
objects that in turn depend on the dependent objects. DISPLAY USE OF repeats
this process until it finds all objects that depend directly or indirectly on object.
DISPLAY USE OF object [ AT { \node } ]
[ { (\node [,\node] ... ) } ]
[ , { BRIEF | STANDARD } ] ;
BRIEF Display name, object type, and status of dependent objects and
programs.
STANDARD Display name, object type, status, owner, security, number of
partitions, and catalog name for the object and for dependent
objects and programs.