SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-57
Examples—DISPLAY USE OF
>> DISPLAY USE OF \SYS1.$VOL.PERSNL.EMPLOYEE, BRIEF;
Object Name Type S
------------------------------------- ---- -
0 \SYS1.$VOL1.PERSNL.EMPLOYEE TA
1 \SYS1.$VOL1.PERSNL.EMPLIST PV
1 \SYS1.$VOL1.PERSNL.XEMPDEPT IN
1 \SYS1.$VOL1.PERSNL.XEMPNAME IN
1 \SYS1.$DATA.ZYQ39483.Z000002H PG
PATH/usr/empinfo/reports/app.exe
U = Undefined node N = Node unavailable
@ = Node not in list * = Previously displayed
T = Unsupported type ? = System error
Number of unique dependencies : 4
Number of direct dependencies : 4

This example displays a STANDARD-format list of all objects and registered
programs in the network that depend on a table named EMP on subvolume
\SYS1.$VOL1.HR. (The display layout has been modified slightly to fit the page
width.)
>> DISPLAY USE OF \SYS.$VOL.PERSNL.EMPLOYEE;
Object Name Type S P Owner Name Secure
------------------------ ---- - --- ----------- ------
Catalog Name
-------------
0 \SYS1.$VOL1.HR.EMP TA GROUP.NAME CUCU
$VOL1.HR
1 \SYS1.$VOL1.HR.EMPL PV GROUP.NAME CUCU
$VOL1.HR
1 \SYS1.$VOL1.HR.XEMP IN GROUP.NAME CUCU
$VOL1.HR
1 \SYS1.$DATA.ZYQ39483.Z000002H PG
PATH/usr/empinfo/reports/app.exe
OWNER: GRP.FRED SECURITY -rwxr-x--x
GROUP: NonStop
$VOL1.HR
1 \SYS1.$VOL1.HR.GPROG PG GROUP.NAME CUCU
U = Undefined node N = Node unavailable
@ =Node not in list * = Previously displayed
T = Unsupported type ? = System error
Number of unique dependencies : 4
Number of direct dependencies : 4
DISTINCT Clause
DISTINCT is a clause that removes duplicate rows from a result table. It is used in
many search conditions and in the SELECT statement.
For information, see SELECT Statement on page S-18 or the entry for a specific
search condition (for example, AVG or SUM).