SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Planning Database Security and Recovery
HP NonStop SQL/MX Installation and Management Guide—523723-004
5-18
Using the TMF DUMP FILES Command
For example, if an SQL/MX table to be dumped has the definition:
CREATE TABLE CAT.SCH.T056T11
(
WREN INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, JUNCO INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, BLACKBIRD INT DEFAULT NULL
, CONSTRAINT CAT.SCH.T056T11_104569472_0002 PRIMARY KEY (WREN
ASC, JUNCO ASC) NOT DROPPABLE
, CONSTRAINT CAT.SCH.T056T11_104569472_0001 CHECK
(CAT.SCH.T056T11.WREN IS NOT NULL AND CAT.SCH.T056T11.JUNCO
IS NOT NULL) NOT DROPPABLE
)
LOCATION \NSK.$DATA1.ZSDADLON.NSPD2Q00
PARTITION
(
ADD FIRST KEY (30)
LOCATION \NSK.$DATA2.ZSDADLON.N0FK2Q00
, ADD FIRST KEY (170)
LOCATION \NSK.$DATA3.ZSDADLON.N75R2Q00
, ADD FIRST KEY (190)
LOCATION \NSK.$DATA4.ZSDADLON.OFVY2Q00
, ADD FIRST KEY (300)
LOCATION \NSK.$DATA5.ZSDADLON.ONL42Q00
)
STORE BY (WREN ASC, JUNCO ASC)
;
CREATE UNIQUE INDEX T056IN6 ON CAT.SCH.T056T11
(
BLACKBIRD ASC
)
LOCATION \NSK.$DATA1.ZSDADLON.R70U5Q00
PARTITION
(
ADD FIRST KEY (150)
LOCATION \NSK.$DATA2.ZSDADLON.SFQ15Q00
, ADD FIRST KEY (180)
LOCATION \NSK.$DATA3.ZSDADLON.SNG85Q00
)
;