Ispirer Website Ispirer Toolkit Overview Free Trial

IBM DB2 AS/400 (iSeries): Advanced Options

To open some additional options for target database at the “Target Options” page of SQLWays Wizard you can press on button “Advanced”:

Common Options

Use Full Path To BIN Directory

If checked, the full path to native db2.exe utility for command will be generate by SQLWays Wizard tool.

Timestamp Format

If you want to specifies the format of the timestamp columns in the text file when the target database is IBM DB2 you could use this option. Possible values - IBM DB2, ISO. The default value is IBM DB2 that means using the IBM DB2 native format of timestamps: YYYY-MM-DD-HH.MI.SS.FFFFFF. The IBM DB2 IMPORT command requires this format to import text files containing timestamps not enclosed by double quotes (TAB delimited output format e.g.). The ISO format of timestamps is YYYY-MM-DD HH:MI:SS.FFFFFF. If ISO is specified the IBM DB2 IMPORT command will contain timestamp values in the ISO format, when they are enclosed by double quotes (CSV output format e.g.). Note. This option is ignored in case of any values in the option DATETIME_FORMAT is specified (see earlier in the [DATA] subsection). For example, when DATETIME_DATATYPE=DATE is specified, the datetime datatypes will be converted to DATE in IBM DB2.

Utilities Options

Use the IMPORT\LOAD Command

These two options control what command will be used to move data into the IBM DB2 database. By default LOAD command is checked.

Load From a Remote Client

If checked, in the IBM DB2 LOAD command the CLIENT option will be used. This option specifies that the data can reside on a remote client. Otherwise, the data must reside on the IBM DB2 server.

Nonrecoverable Load

If this option is checked, the NONRECOVERABLE option is added to the IBM DB2 LOAD command and means that load transaction is to be marked as non-recoverable, and that it will not be possible to recover it by a subsequent roll forward action. With this option the table spaces are not put in backup pending state following the load operation in case of database is configured to support online backups.

Modified By

Specifies additional options that are added to the modified by option of the IBM DB2 IMPORT and LOAD utilities if you need other options to be added to the modified by option. Some options like character, column delimiters and others are added to the IBM DB2 IMPORT/LOAD scripts by SQLWays Wizard. For example, setting modifiedby_options=usedefaults delprioritychar will add this options to the modified by option in each script for the IBM DB2 IMPORT/LOAD utilities.

Batch Size

Specifies that the download utility should set consistency points after every n lines. This value is converted to a page count and rounded up to intervals of the extent size. This option should be selected if the load operation will be monitored using LOAD QUERY, because of message is issued at each consistency point. If the value of n is not sufficiently high, the synchronization of activities performed at each consistency point will impact performance.


Database Name

If you want to add IN [database_name] clause to the converted table definition, which controls in what database this table should be created? you should set up this option. By default this option is empty.


Specifies the table space in which the tables will be created. The pointed table space must exist,be a REGULAR and in case of no other table space is specified, all table parts will be stored in this table space. The default value is USERSPACE1.


Specifies the existing REGULAR DMS table space in which any indexes on the tables will be created.

Large Objects

Specifies the existing REGULAR DMS table space in which the values of any long columns (LONG VARCHAR, LONG VARGRAPHIC, LOB data types) will be stored.

Use Separate Tablespaces

If checked, separate tablespaces will be used for each table.

Use Tablespace Names From Source Database

If this option is checked the tablespace name from source database will be used for tables and indexes.


Single-Byte Codepage

This option specifies Single-Byte codepage for using in the .IXF file, generated during the conversion step.

Double-Byte Codepage

This option specifies Double-Byte codepage for using in the .IXF file, generated during the conversion step.