Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-29
Restore Objects
sqlmx-table
is a valid SQL/MX table name.
PARTITION(sqlmx-part[,sqlmx-part ]...)
is one or more valid SQL/MX table partition names of the table
specified in sqlmx-table. If you specify the TPART object type, you
must specify at least one table partition name and the PARTONLY job
option. You must enclose the names of the table partitions in
parentheses.
sqlmx-index
is a valid SQL/MX index name.
IPART
is the name of an index partition.
PARTITION(sqlmx-ipart[,sqlmx-ipart ]...)
is one or more valid SQL/MX partition names of the INDEX specified
by sqlmx-index. If you specify the IPART object type, you must
specify a partition name.
sqlmx-target
is the name of a valid SQL/MX object that designates the parent object
for the sqlmx-object being restored. The target parent object must
already exist and be one level higher in the object hierarchy than the
object being restored. For example, if you are restoring an SQL/MX
table, the only valid target parent object is a schema. For more
information about the object hierarchy, see Supported SQL/MX Objects
on page 1-8.
The sqlmx-source-object becomes a subordinate object of
sqlmx-target. If you do not specify a target, the object is restored to
the same parent object as at the time of the backup.
WHERE expression
allows exclusions from an sqlmx-restore-object. You can exclude some
objects from the restore by specifying qualifying criteria such as user ID, time,
or the number of bytes in the file. The order of precedence in expression
evaluation is parentheses, NOT, AND, OR. Parentheses within a WHERE
expression are optional. For SQL/MX, it is any of:
{ sqlmx-qualifier }
{ NOT sqlmx-qualifier }
{ (sqlmx-qualifier AND sqlmx-qualifier ... ) }
{ (sqlmx-qualifier OR sqlmx-qualifier ... ) }