Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-37
CONSTRAINTS Job Option
CONSTRAINTS Job Option
Constraints are rules that protect the integrity of data in a table by restricting the values
in a particular column or set of columns to those that meet the conditions of the
constraints. Use this job option to specify which constraints to restore from the source
table. INCLUDED is the default.
INCLUDED
restores the primary key, unique, not null, and check constraints from the source
table.
EXCLUDED
restores the NOT NULL constraints from the source table. It also restores the
PRIMARY KEY constraint from the source table only if it is NOT DROPPABLE.
Guidelines

The CONSTRAINTs job option is supported only for SQL/MX objects. If you specify
this job option but do not specify SQL/MX objects, an error occurs.

If you specify CONSTRAINTS INCLUDED during the RESTORE command, it is
meaningful only if CONSTRAINTS INCLUDED was specified or defaulted to during
the BACKUP command.
OUT Job Option on page 7-47 SQL/MX
PAGELENGTH Job Option
on page 7-47 Standard
PARTONLY Job Option
on page 7-48 SQL/MX
RESTOREBKUPSPEC Job Option
on page 7-49 Standard
RESTOREDIR Job Option
on page 7-49 Standard
SHOWDDL Job Option
on page 7-50 SQL/MX
SHOWDDLLOC Job Option
on page 7-50 SQL/MX
OBEYDDL Job Option
on page 7-51 SQL/MX
SQLDATA Job Option
on page 7-52 SQL/MX
TAPEDATE Job Option
on page 7-52 Standard
TAPEDISPOSITION Job Option
on page 7-53 Standard
VERIFYDISK Job Option
on page 7-53 Standard
VERIFYTAPE Job Option
on page 7-53 Standard
CONSTRAINTS { EXCLUDED | INCLUDED }
Table 7-5. RESTORE Job Options (page2of2)
RESTORE Option Category