Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer DB2 Migration overview.

Ispirer SQLWays Database Migration Software

[IBM DB2] Subsection

This subsection is used to adjust script generations when IBM DB2 is the target database, and to specify properties when it is the source database.

BIN - Specifies the directory where the IBM DB2 utilities like CLP, IMPORT and LOAD are located.
DATABASE - Specifies the database name that is used in generated scripts for the IBM DB2 utilities.
USER - Specifies the user name that is used in generated scripts for the IBM DB2 utilities.
PWD - Specifies the user password that is used in generated scripts for the IBM DB2 utilities.
USE_LOAD_COMMAND - If Yes is specified, the IBM DB2 LOAD command is used to move data into the IBM DB2 database. Possible values - Yes, No. The default value is No, which means that the IBM DB2 IMPORT command is used.
LOAD_FROM_CLIENT - If Yes is specified, the CLIENT option is used in the IBM DB2 LOAD command. This option specifies that the data can reside on a remote client. Otherwise, the data must reside on the IBM DB2 server.

Possible values - Yes, No. The default value is No. The CLIENT option in the LOAD command is available in IBM DB2 7.1 or later.

LOAD_NONRECOVERABLE - If Yes is specified, the NONRECOVERABLE option is added to the IBM DB2 LOAD command. This option specifies that the 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, when the database is configured to support online backups, table spaces are not put in backup pending state following the load operation.

Possible values - Yes, No. The default value is No.

IMPORT_OPTION - Specifies a mode, under which the import utility will execute. Possible values are INSERT (Adds the imported data to the table without changing the existing table data), INSERT_UPDATE (Adds rows of imported data to the target table, or updates existing rows of the target table with matching primary keys) and REPLACE (Deletes all existing data from the table by truncating the data object, and inserts the imported data. The table definition and the index definitions are not changed). The default mode is INSERT.
LOAD_OPTION - Specifies a mode, under which the load utility will execute. Possible values are INSERT (Adds the loaded data to the table without changing the existing table data) and REPLACE (Deletes all existing data from the table, and inserts the loaded data. The table definition and index definitions are not changed). The default mode is INSERT.
MODIFIEDBY_OPTIONS - Specifies additional options that are added to the modified by option of the IBM DB2 IMPORT and LOAD utilities.

Some options like character, column delimiters and others are added to the IBM DB2 IMPORT/LOAD scripts by SQLWays. You can use this option if you need other options to be added to the modified by option.

For example, set modifiedby_options=usedefaults delprioritychar and these options will be added to the modified by option in each script for the IBM DB2 IMPORT/LOAD utilities.

TIMESTAMP_FORMAT - This option specifies the format of the timestamp columns in the text file when the target database is IBM DB2. Possible values - IBM DB2, ISO.
The default value is IBM DB2 that means using the IBM DB2 native format of timestamps. The IBM DB2 native format is 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.).
When ISO is specified, the ISO format of timestamps will be used. The ISO format is YYYY-MM-DD HH:MI:SS.FFFFFF. The IBM DB2 IMPORT command can import timestamp values in the ISO format, when they are enclosed by double quotes (CSV output format e.g.).

Note. This option is ignored when any value is specified in the option DATETIME_FORMAT (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.

TABLESPACE - Specifies the table space in which the tables will be created. The table space must exist, and be a REGULAR table space. If no other table space is specified, all table parts will be stored in this table space. The default value is USERSPACE1.
INDEX_TABLESPACE - Specifies the table space in which any indexes on the tables will be created. The specified table space must exist, be a REGULAR DMS table space.
LONG_TABLESPACE - Specifies the table space in which the values of any long columns (LONG VARCHAR, LONG VARGRAPHIC, LOB data types) will be stored. The table space must exist, be a LONG DMS table space.
SELECT_EXACT_ORDER - This option was created for direction Sybase ASE - DB2 to get exactly the same order of output rows as in the source. Available values are 'yes' and 'no' (default). When set to 'yes' SQLWays explicitly adds all the columns listed in SELECT clause to ORDER BY clause as Sybase sorts by all columns implicitly.
DECLARE_TEMP2CREATE_TEMP - This option was created for direction Sybase ASE - DB2. Available values are 'yes' and 'no' (default). When set to 'yes' SQLWays converts Sybase SELECT INTO tempdb and CREATE TABLE tempdb to DB2 CREATE GLOBAL TEMPORARY TABLE. Otherwise these statements are converted to DECLARE GLOBAL TEMPORARY TABLE.
DYNAMIC_RESULT_SETS - This option was created for DB2 as a target database. Available values are 'yes' and 'no' (default). When set to 'yes' SQLWays converts CREATE PROCEDURE statement to DB2 procedure with DYNAMIC RESULT SETS clause.
DYNAMIC_RESULT_SETS_VALUE - This option is used together with the option DYNAMIC_RESULT_SETS. Default value is 100.

To specify IBM DB2 options using the SQLWays wizard

SQLWays Wizard - IBM DB2 Advanced Options Page