Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-67
SQL/MX Restore Examples
Restoring a Delimited SQL/MX Schema
To restore all objects in “CATalog1”.”SCHema1”
BR> RESTORE =mytape, MX SCHEMA “CATalog1”.”SCHema1”;
Restoring SQL/MX Tables
To restore all objects in table cat1.sch2.tab2:
BR> RESTORE =mytape, MX TABLE cat1.sch2.tab2;
The table cat1.sch2.tab2 and all its subordinate objects as shown in Table 7-10 are
restored.
To restore all objects in two tables:
BR> RESTORE =mytape, MX (TABLE cat1.sch1.tab1, TABLE
BR+> cat1.sch2.tab2);
Both tables and all their subordinate objects as shown in Table 7-11
are restored:
Note. SQL/MX schemas containing delimiters are supported only on systems running H06.06
or later H-series RVUs.
Table 7-10. Table and Subordinate Objects Restored
Catalog Schema Table
Table
Partition
or Index
Index
Partition Description
cat1.sch2.tab2 Subordinate table
of cat1.sch2
-tpart1 Subordinate table
partition of tab2
-tpart2 Subordinate table
partition of tab2
-tpart5 Subordinate table
partition of tab2