SQL/MP Installation and Management Guide

Querying SQL/MP Catalogs
HP NonStop SQL/MP Installation and Management Guide—523353-004
6-2
Using the DISPLAY USE OF Command
\SYS1.$V.CAT1 Catalog \SYS2.$V.CAT2 Catalog
USAGES Table USAGES Table
\SYS1.$V.SV.TABLEA has dependent \SYS2.$V.P.PROG2 uses
object \SYS2.$V.P.PROG2 \SYS1.$V.SV.TABLEA
You can display dependent objects by using the DISPLAY USE OF utility or by directly
querying individual USAGES tables. The DISPLAY USE OF utility is convenient to use
because it searches multiple USAGES tables for dependencies. The system prepares
the display by searching all the catalogs for all the objects that depend directly or
indirectly on the object you specify in the command.
Using the DISPLAY USE OF Command
The DISPLAY USE OF command enables you to specify a table, index, view, or
collation. The utility displays the objects that depend on the specified object.
The DISPLAY USE OF utility has two formats: standard and brief. The standard format
is the default. The brief format does not display the partition flags, the owners, the
security of the objects, or the catalog name.
The next examples show the standard and brief formats of the DISPLAY USE OF
utility. Each example includes the DISPLAY USE OF command and the information
displayed.
This example shows the standard format:
>> DISPLAY USE OF INVENT.SUPPLIER;
Object Name Type S P Owner Name Secure
---------------------------------------- ---- - -- ---------------- ------
Catalog Name
---------------------------------
0 \SYS1.$VOL.INVENT.SUPPLIER TA AUSER .ERIC NCNC
$SQL.INVENT
1 \SYS1.$VOL.INVENT.XSUPPNAM IN AUSER .ERIC NCNC
$SQL.INVENT
2 \SYS1.$VOL.AUSERSV.OPROG2 PG AUSER .PAT NCNC
$SQL.SALES
1 \SYS1.$VOL.AUSERSV.OPROG2 PG *
U = Undefined node N = Node unavailable T = Unsupported type
@ = Node not in list * = Previously displayed ? = System error
Number of unique dependencies : 2
Number of direct dependencies : 1