Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-33
Restore Objects
second
is a 2-digit integer in the range 00 through 59.
EOF eof-conditional eof-number
selects a table partition based on its number of bytes.
eof-conditional
is any of:
<
>
<=
=
>=
<> (not equal to)
eof-number
is the number of bytes in a table partition.
Filters for SQL/MX Objects
For SQL/MX objects, the filters are applied only to certain types of objects as shown in
Table 7-4. You cannot filter SQL/MX constraints. Parent objects are restored if the filter
does not apply to them. For example, WHERE EOF applies only to table partitions. If
you specify RESTORE of a schema WHERE EOF>n, all tables in the schema are
restored, and only table partitions greater than the indicated size are restored.
OWNER = user-id
selects a schema based on the user ID. It is a NonStop user ID in one of these
forms:
{ group-name.user-name }
{ group-name.* }
{ group-number, user-number }
Table 7-4. SQL/MX Filters
CATALOG SCHEMA TABLE INDEX PARTITIONS
OWNER Ignored Valid Ignored Ignored Ignored
CREATIONTIME Ignored Ignored Valid Ignored Ignored
LASTOPENTIME Ignored Ignored Ignored Ignored Valid
MODTIME Ignored Ignored Ignored Ignored Valid
REDEFINITIONTIME Ignored Ignored Valid Valid Ignored
EOF Ignored Ignored Ignored Ignored Valid
TABLE Valid Valid Valid Valid Valid