Backup and Restore 2 Manual

BRCOM BACKUP Command
Backup and Restore 2 Manual—522696-019
6-15
Backup Object
sqlmx-object
is the set of SQL/MX objects to be backed up, which can be regular or
delimited.
The sqlmx-object is:
sqlmx-object-type
is one of these object types:
{ CAT *| CATALOG * }
{ CAT | CATALOG }
{ SCH | SCHEMA }
{ TBL | TABLE }
{ IND | INDEX }
CAT * | CATALOG *
is the object type for the set of all catalogs and their subordinate
objects. If you specify *, you must not specify
sqlmx-source-object. The * is required.
CAT | CATALOG
is the object type for a catalog.
SCH | SCHEMA
is the object type for a schema.
TBL | TABLE
is the object type for a table.
Note. SQL/MX tables, catalogs, and schemas containing delimiters are supported
only on systems running J06.03 or later J-series RVUs and H06.06 or later H-series
RVUs. SQL/MX indexes containing delimiters are supported only on systems running
J06.08 or later J-series RVUs and H06.19 or later H-series RVUs.
{sqlmx-object-type sqlmx-source-object }
{TPART sqlmx-table PARTITION(sqlmx-part [,sqlmx-part ]...) }
}
{IPART sqlmx-index PARTITION (sqlmx-ipart [,sqlmx-ipart]...)
}