Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-68
SQL/MX Restore Examples
Restoring a Delimited SQL/MX Table
To restore all objects in “TAble1”:
BR> RESTORE =mytape, MX TBL “CATalog1”.”SCHema1”.”TAble1”;
Table 7-11. Two Tables and Subordinate Objects Restored
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description
cat1.sch1.tab1 Subordinate
table of
cat1.sch1
-tpart1 Subordinate
table partition of
tab1
-tpart2 Subordinate
table partition of
tab1
-ind1 Subordinate
index of tab1
-ipart1 Subordinate
index partition of
the index for
tab1
cat1.sch1.tab2 Subordinate
table of
cat1.sch2
-tpart1 Subordinate
table partition of
tab2
-tpart2 Subordinate
table partition of
tab2
-tpart5 Subordinate
table partition of
tab2
Note. SQL/MX tables containing delimiters are supported only on systems running H06.06 or
later H-series RVUs.