Online Documentation for Data Export for DB2

SQL options


The SQL Options tab allows you to set options for SQL as the output format (as a set of INSERT statements).

 

Step 7 - Format-specific options - SQL

Destination server

Select the RadioButton ANSI SQL-92 standard or define the type of DBMS you need to export data for (to achieve maximum compatibility). The result script will be generated in compliance with the specifications of the selected server type:

RadioButton DB2

RadioButton InterBase/Firebird

RadioButton Microsoft® SQL Server™

RadioButton MySQL

RadioButton Oracle

RadioButton PostgreSQL

 

Table options

This group allows you to add the CREATE TABLE statement to the result script, define the name for the table being exported and select SQL dialect.

 

CheckBox Add 'IDENTITY_INSERT' statement (for export to MS SQL)

Allow explicit values to be inserted into the identity column of a table.

 

Commit options

This group allows you to add the COMMIT statement after a defined number of records or at the end of the script. You can also define the commit statement (COMMIT; by default) in the corresponding edit-box.

 

Other options

CheckBox Create multiple insert statement

Check this option to perform insert operation using multiple insert statements.

 

Export null values as

Specify the representation of NULL values in the result script.

 

Statement term

Define the character denoting the end of each SQL statement (semicolon by default).

 

CheckBox Add byte order mark (BOM)

With this option enabled the byte order mark is added to each TXT file.