Online Documentation for SQL Manager for DB2

Customizing script options


This step allows you to customize common script options and data options for the extraction process.

 

Script options

 

CheckBox Extract dependent objects

This option determines objects' dependencies usage in the extraction process. Check the option to extract all objects that the selected objects depend on.

 

CheckBox Extract privileges

Tick off the option if you want the privileges (permissions on the objects) to be extracted.

 

CheckBox Generate "DROP" statements for objects

Check the option to add the DROP statements for the extracted objects in the result script.

 

Extract Database - Customizing script options

 

 

Data options

 

Records in Block / CheckBox Insert COMMIT statement after each block

These controls allow you to define whether the COMMIT statement is inserted into the script or not, and to specify the number of records in each block to be supplemented with this statement.

 

CheckBox Extract table data just after its definition

If this option is selected, the INSERT INTO commands for each table follow the table definition (CREATE TABLE).

 

 

CheckBox Abort extraction on error

This option determines whether the extraction process should be stopped or forced to continue if an error occurs.

 

 

Click the Next button to proceed to the last step of the wizard.