Step 9 - Setting common options

Using this step of the wizard you can set final import options.

Commit

Commit when done

Check this option to commit the transaction after all records are imported.

Commit after each ... records

These control allows you to define the number of records in each block to be supplemented with the COMMIT statement.

Rollback on error

Check this option to rollback the transaction if an error occurred.

Record Count

Import all records

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

Import only ... record(s)

Specifies the number of records to be imported.

Import empty rows

If this option is checked then empty records are imported.

Auto trim values

Check this function to remove all leading and trailing white-space characters from all imported records.

Save Result SQL Script to File

This option allows you to save the result SQL script of the import operation to an external *.sql file on your disk drive.

Specify the script file name and select its location using the button which calls the Save As... dialog.

Skip this step

Check this option to skip the current step in the future. To edit the list of skipped steps, use the Skipped Steps group available in the General section of the Preferences dialog.

When you are done, press the Next button to proceed to the next step.