Backup and Restore 2 Manual

BRCOM RESTORE Command
Backup and Restore 2 Manual—522696-019
7-50
SHOWDDL Job Option
SHOWDDL Job Option
Use this job option to generate OSS files containing DDL information.
ON
generates one or more OSS files containing DDL information. These files are
created in addition to the objects normally being restored.
OFF
does not generate OSS files containing DDL information. OFF is the default.
Guidelines

This job option is not supported for OSS.

The SHOWDLL job option is supported only for SQL/MX objects. If you specify this
job option but do not specify any SQL/MX objects, an error occurs.

If you specify SHOWDLL ON, you must also specify the SHOWDDLLOC job
option.

You can use the DDL information to manually create triggers, views, referential
integrity constraints, and stored procedures after the RESTORE. The generated
files are named as shown in Table 7-6 on page 7-50. n starts at 1 and is
incremented. A new file is created every time the current file becomes full.
SHOWDDLLOC Job Option
Use this job option to place files containing DDL information in the specified OSS
directory.
SHOWDDL { OFF | ON }
Table 7-6. DDL Files
File Name For...
Subordinate
object of...
SHOWDDLn_RI_Constraints Referential integrity Schema
SHOWDDLn_Stored_Procedures Java stored procedures Schema
SHOWDDLn_Triggers Triggers Table
SHOWDDLn_Views Views Schema
SHOWDDLLOC oss-directory