SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-113
Examples of MXGNAMES
\PNODE.$VOL2.ZSDA126A.BXNL2R00 TO \BNODE.$VOL2.ZSDA126A.BXNL2R00,
\PNODE.$VOL3.ZSDA126A.BXNL3R00 TO \BNODE.$VOL3.ZSDA126A.BXNL3R00,
\PNODE.$VOL4.ZSDA126A.BXNL4R00 TO \BNODE.$VOL4.ZSDA126A.BXNL4R00,
\PNODE.$VOL5.ZSDA126A.BXNL5R00 TO \BNODE.$VOL5.ZSDA126A.BXNL5R00,
\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).

In this example, the table contains an IDENTITY column:
CREATE TABLE CAT.SCH.TABLE_IDENTITY
(
I LARGEINT GENERATED BY DEFAULT AS IDENTITY
(START WITH 0 INCREMENT BY 1 MAXVALUE 9223372036854775807
MINVALUE 0 NO CYCLE)
LOCATION \DMR15.$SYSTEM.ZSDWDPR4.WD4DR900
-- NOT NULL NOT DROPPABLE
, CONSTRAINT CAT.SCH.TABLE_IDENTITY_849996266_9538 CHECK
(CAT.SCH.TABLE_IDENTITY.I IS NOT NULL) NOT DROPPABLE
)
LOCATION \DMR15.$SYSTEM.ZSDWDPR4.L26KR900