SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-71
Examples of MXGNAMES
\PNODE.$VOL6.ZSDA126A.BXNL6R00 TO \BNODE.$VOL6.ZSDA126A.BXNL6R00,
\PNODE.$VOL1.ZSDA126A.QDXWG100 TO \BNODE.$VOL1.ZSDA126A.QDXWG100,
\PNODE.$VOL2.ZSDA126A.QDXWG200 TO \BNODE.$VOL2.ZSDA126A.QDXWG200,
\PNODE.$VOL3.ZSDA126A.QDXWG300 TO \BNODE.$VOL3.ZSDA126A.QDXWG300,
\PNODE.$VOL4.ZSDA126A.QDXWG400 TO \BNODE.$VOL4.ZSDA126A.QDXWG400,
\PNODE.$VOL1.ZSDA126A.BXNW1R00 TO \BNODE.$VOL1.ZSDA126A.BXNW1R00,
\PNODE.$VOL2.ZSDA126A.BXNW2R00 TO \BNODE.$VOL2.ZSDA126A.BXNW2R00,
\PNODE.$VOL3.ZSDA126A.BXNW3R00 TO \BNODE.$VOL3.ZSDA126A.BXNW3R00,
\PNODE.$VOL4.ZSDA126A.BXNW4R00 TO \BNODE.$VOL4.ZSDA126A.BXNW4R00,
\PNODE.$VOL1.ZSDA126A.QDX1G100 TO \BNODE.$VOL1.ZSDA126A.QDX1G100,
\PNODE.$VOL2.ZSDA126A.QDX1G200 TO \BNODE.$VOL2.ZSDA126A.QDX1G200,
\PNODE.$VOL3.ZSDA126A.QDX1G300 TO \BNODE.$VOL3.ZSDA126A.QDX1G300,
\PNODE.$VOL4.ZSDA126A.QDX1G400 TO \BNODE.$VOL4.ZSDA126A.QDX1G400,
\PNODE.$VOL5.ZSDA126A.QDX1G500 TO \BNODE.$VOL5.ZSDA126A.QDX1G500
)
•
This example prepares a list of file names to be used with RESTORE. The input is
SHOWDDL text.
MXGNAMES -Showddl=$VOL1.SQLSTUFF.SHOWD123 -output=NAMELST2 -BR2
-node=\bnode
Suppose the contents of the file SHOWD123 are the same as for the second
example. The contents of output file NAMELST2 is:
LOCATION
(
\PNODE.$VOL1.ZSDA126A.BXNW1R00 TO \BNODE.$VOL1.ZSDA126A.BXNW1R00,
\PNODE.$VOL2.ZSDA126A.BXNW2R00 TO \BNODE.$VOL2.ZSDA126A.BXNW2R00,
\PNODE.$VOL3.ZSDA126A.BXNW3R00 TO \BNODE.$VOL3.ZSDA126A.BXNW3R00,
\PNODE.$VOL4.ZSDA126A.BXNW4R00 TO \BNODE.$VOL4.ZSDA126A.BXNW4R00,
\PNODE.$VOL5.ZSDA126A.BXNW5R00 TO \BNODE.$VOL5.ZSDA126A.BXNW5R00,
\PNODE.$VOL6.ZSDA126A.BXNW6R00 TO \BNODE.$VOL6.ZSDA126A.BXNW6R00,
\PNODE.$VOL1.ZSDA126A.QDX1G100 TO \BNODE.$VOL1.ZSDA126A.QDX1G100,
\PNODE.$VOL2.ZSDA126A.QDX1G200 TO \BNODE.$VOL2.ZSDA126A.QDX1G200,
\PNODE.$VOL3.ZSDA126A.QDX1G300 TO \BNODE.$VOL3.ZSDA126A.QDX1G300,
\PNODE.$VOL4.ZSDA126A.QDX1G400 TO \BNODE.$VOL4.ZSDA126A.QDX1G400
)
•
This example prepares a list of file names to be used with RESTORE. The input is
an SQL table name.
MXGNAMES CAT.SCH.T126A -output=NAMELST3 -BR2 -node=\bnode
The contents of NAMELST3 are identical to the output file in the sixth example
(assuming the definition of table CAT.SCH.T126A is the same).