Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-28
Restore Objects
It is one of these:
{ sqlmx-source }
{ (sqlmx-source [{, TARGET | TGT} sqlmx-object-type
sqlmx-target)]) }
sqlmx-source
is the set of SQL/MX objects to be restored. The object specified and all its
subordinate objects are restored unless specifically excluded. It is one of
these:
{sqlmx-object-type sqlmx-source-base }
{TPART sqlmx-table PARTITION ( sqlmx-part
[ , sqlmx-part ]...) }
{sqlmx-index sqlmx-source-base }
{IPART sqlmx-index PARTITION ( sqlmx-ipart
[ , sqlmx-ipart ]...) }
sqlmx-object-type
is the type of object specified in sqlmx-source-base or sqlmx-
target. You must specify an sqlmx-object-type for the sqlmx-
target that is one level higher in the hierarchy than the sqlmx-
object-type you specify for the sqlmx-source. For more
information, see Table 7-1 on page 7-20.
It is one of these:
{ CAT | CATALOG }
{ CAT * | CATALOG * }
{ SCH | SCHEMA }
{ TBL | TABLE }
{ IND | INDEX }
sqlmx-source-base
is a valid SQL/MX object, such as the name of a catalog, schema, or
table in the source object of a backup job. The specified object and all
its subordinate objects are restored. Wild cards are not permitted in
the sqlmx-source-base.
TPART
is the name of a table partition.