Select to include the database in the DDL that is generated.
Select to include the related privileges that were defined with the database in the DDL that is generated.
Select to include the table spaces associated with this database in the DDL that is generated.
Select to include the related privileges that were defined for table spaces in the selected database in the DDL that is generated.
Select to include the tables associated with this database in the DDL that is generated.
Select to include the related privileges that were defined for the tables associated with the selected database in the DDL that is generated.
Select to include the views associated with this database in the DDL that is generated.
Select to include the related privileges that were defined for views associated with the selected database in the DDL that is generated.
Select to include the indexes associated with this database in the DDL that is generated.
Select to include the foreign keys associated with this database in the DDL that is generated.
Select to include the synonyms associated with this database in the DDL that is generated.
Select to include the aliases associated with this database in the DDL that is generated.
Select to include the labels associated all valid objects in the database in the DDL that is generated.
Select to include the comments associated with all valid objects inthis database in the DDL that is generated.
Select to extract the environment with a new database name. This check box is only available when database is a selected object from the Objects page.
Type a new database name with which the generated DDL will be identified. The name can be no longer than 8 characters.
Select to extract the environment with a new storage group name for the table spaces associated with this database. This check box is only available when table space is a selected object from the Objects page.
Type a new storage group name with which the generated DDL will be identified. This field is only available when table space is a selected object from the Objects page.
Select to extract the environment with a new storage group name for the index spaces associated with this database. This check box is only available when index is a selected object from the Objects page.
Type a new storage group name with which the generated DDL will be identified. This field is only available when index is a selected object from the Objects page.
Select to extract the environment with a new name for the owner of the database.
Type a new owner name with which the generated DDL will be identified. This name is generally the authorization ID.
Specify the index or table space allocation options to determine which columns in the DB2 for OS/390 catalog tables are used for space allocation calculations in the DDL that is generated. This field is only available when either index or table space is a selected object from the Objects page.
Specify the version for which the extracted environment is generated. If the version selected is earlier than Version 5, the subsystem is DB2 for MVS. Otherwise, it is DB2 for OS/390.
Specify the frequency with which you commit the statements within the environment.
Specify whether to keep the DB2 defaults as originally defined, or erase wherever possible.
Type a data set name that can be used to contain the report of the generated DDL.
Type a data set name that can be used to contain the actual generated DDL.
Type the direct access unit name or the device type that will be used to allocate the associated data set. Some common device types are 3380, 3390, and 9340 or tape.
Type the direct access unit name or the device type that will be used to allocate the associated data set. Some common device types are 3380, 3390, and 9340 or tape.
Type the volume serial number for the associated data set. This must be a valid MVS volume serial name. Example: DSNV01.
Type the volume serial number for the associated data set. This must be a valid MVS volume serial name. Example: DSNV01.
Type the name of a file in your workstation environment that can be used to contain the report of the generated DDL.
Type the name of a file in your workstation environment that can be used to contain the actual generated DDL.
Opens a Save As window so that you can select or rename a file on your workstation.
Opens a Save As window so that you can select or rename a file on your workstation.
Submits the data in the window and closes the window.
Displays the SQL statements that would be generated by your choices in this window.
Cancels any unsaved changes and closes this notebook.