IBM DB2 Advanced Options

In the BIN directory box, enter the path to the folder where the IBM DB2 utilities like CLP, IMPORT and LOAD are located. You can click (...) to browse for this folder.

By default Use the IMPORT command is clicked in the Utilities options box, so the data is imported to a IBM DB2 database.

In the Mode box, select the mode in which the IMPORT utility is executed. Possible modes 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.

If Use the LOAD command is clicked in the Utilities options box, the data is loaded to a IBM DB2 database.

In the Mode box, select the mode in which the LOAD utility is executed. Possible modes 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.

If the Load from a remote client check box is selected, the data resides on a remote client. By default the Load from a remote client check box is clear, so the data resides on the IBM DB2 server. The CLIENT option in the LOAD command is available in IBM DB2 7.1 or later.

If the Nonrecoverable load check box is selected, the load transaction is marked as non-recoverable, and it is not 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. By default the Nonrecoverable load check box is clear.

In the Modified by box, enter 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.

In the Tablespaces box:

In the Tables box, enter 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 table space is USERSPACE1.

In the Indexes box, enter 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.

In the Large objects box, enter 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.

In the Timestamp format box, select the format of the timestamp columns in the text file when the target database is IBM DB2. Possible formats are IBM DB2, ISO. The default format 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.

Ispirer SQLWays Database Migration Software

IBM DB2 Advanced Options