Online Documentation for SQL Manager for DB2

Customizing common options


Use this step of the wizard to set common import options. The detailed description of these options is given below.

 

Import Data - Customizing common options

 

 

Commit

 

RadioButton Commit when done

Commits the transaction when all records are imported.

 

RadioButton Commit after each block

Inserts the COMMIT statement after a defined number of records.

 

RadioButton Commit changes manually

Select this option if you intend to commit the transaction manually.

 

Block size

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

 

Record count

 

RadioButton Import all records

Specifies that all records of the source file will be imported.

 

RadioButton Import only ... record(s)

Specifies the number of records to be imported.

 

 

When you are done, click the Next button to proceed to the last step of the wizard.