Online Documentation for SQL Manager for DB2

Setting export options


Specify common export options according to your needs.

 

If necessary, you can choose to replace non-print characters in strings with spaces.

 

CheckBox Quote identifiers

Check this option to apply quoting for identifiers in the destination file.

 

CheckBox Use multi insert statements

Use this option to allow multi insert statements in the result script.

 

Data options

 

Records in block

Use the spinner control to define the number of records in each committed block.

 

CheckBox Insert COMMIT after each block

Check this option to add the COMMIT statement after a defined number of records.

 

Export as SQL Script - Setting export options

 

 

Click the Next button to proceed to Exporting as SQL Script.