SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-56
Examples—DISPLAY USE OF

S
A status column that indicates whether any special condition was encountered
during the search for the initial or dependent object. A blank indicates no
special condition was encountered. The meanings of the status codes follow:

P
The number of partitions. A blank indicates that the object is not partitioned.

The user ID of the object's owner.

Secure
The security string for the object.

Catalog Name
The name of the catalog in which the object is described.
The “Number of unique dependencies” field shows the number of objects that
depend directly or indirectly on the initial object. The number does not include
duplicate occurrences of objects.
The “Number of direct dependencies” field shows the number of objects that
depend directly on the object being traced.
Examples—DISPLAY USE OF

This example displays a BRIEF-format list of all objects and registered programs in
the network that depend on the EMPLOYEE table in the subvolume
\SYS1.$VOL1.PERSNL. (The display has been modified slightly to fit the page
width.)
PV Protection view
SV Shorthand view
TA Table
* The object was listed previously; its dependent objects will not be
repeated.
? A system error occurred.
@ The AT option did not include this node.
I The catalog for this object is marked “inconsistent.”
L The object was not found.
N The node with this object is not available.
R The primary partition of this object was not found.
T The type is unsupported.
U The node is undefined.