SQL/MP Installation and Management Guide

Managing Database Applications
HP NonStop SQL/MP Installation and Management Guide—523353-004
10-46
Using SQLCI DUP
Step 1 queries the PROGRAMS table. The query produces a list of program names
from the catalog $OLD1.ACCTG and writes the list in the log file
$VOL1.PGMS.PROGLIST.
>> LOG $VOL1.PGMS.PROGLIST;
>> VOLUME $OLD1.ACCTG;
>> SELECT PROGRAMNAME FROM PROGRAMS;
This list appears in the log file:
PROGRAMNAME
------------------------------
\SYS1.$OLD1.PROGS.PROGA1
\SYS1.$OLD2.PROGS.PROGA2
\SYS1.$OLD3.PROGS.PROGA3
Step 2 displays the edited results of the first entry in the list file. Editing has changed
the listed Guardian programs into DUP commands in an OBEY command file entered
at an SQLCI prompt. This step also displays the SQLCOMP commands entered
through TACL to SQL compile the programs.
>> DUP $OLD1.PROGS.PROGA1, $VOL1.PROGS.*, SAVEALL;
>> DUP $OLD2.PROGS.PROGA2, $VOL2.PROGS.*, SAVEALL;
>> DUP $OLD3.PROGS.PROGA3, $VOL3.PROGS.*, SAVEALL;
>> EXIT
19> SQLCOMP /IN $VOL1.PROGS.PROGA1, OUT $S.#HOLD/
CATALOG $VOL1.ACCTG
20> SQLCOMP /IN $VOL2.PROGS.PROGA2, OUT $S.#HOLD/
CATALOG $VOL1.ACCTG
21> SQLCOMP /IN $VOL3.PROGS.PROGA3, OUT $S.#HOLD/
CATALOG $VOL1.ACCTG
Steps 1 and 2 must be performed for each catalog.