SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-21
PERUSE Command
of the table (the PARTITIONNAME column of the PARTNS table). You can register all
partitions of a table on a node in a single catalog if you want, or put them in separate
catalogs.
Values in FIRSTKEY are in ASCII format, separated by commas. For example, a key
composed of a character and an integer column might have a FIRSTKEY value such
as: “A”,1234.
Guardian names in the PARTNS table are fully qualified and use uppercase
characters.
PERUSE Command
PERUSE is an SQLCI command that invokes the Guardian PERUSE program. Use
PERUSE to examine and change the attributes of your spooled jobs in addition to
monitoring such jobs while they are in the spooler system. For a complete description
of PERUSE, see the Guardian Utilities Reference Manual.
run-options
are one or more standard run-options, separated by commas (as described in
the TACL Reference Manual).
supervisor
is the name of the spooler supervisor that PERUSE communicates with. If
supervisor is omitted, PERUSE uses $SPLS.
Example—PERUSE
This example shows how to start PERUSE from SQLCI:
>>PERUSE;
PERUSE - T9101D20 - (01JUN93) SYSTEM \SYS
Copyright Tandem Computers Incorporated 1978,1982,1983,1984,
1985,1986,1987,1988,1989,1990,1991
SPOOLER SUPERVISOR IS \SYS.$SPLS
JOB BATCH STATE PAGES COPIES PRI HOLD LOCATION REPORT
36 READY 2 1 4 #DEFAULT SALES
533 OPEN 1 4 B #DEFAULT BUDGET
1074 READY 1 1 4 A #DEFAULT MARCH
_
PERUSE [ /run-options/ ] [supervisor] ;