DB Alias tab - DB2 for i, Load Request Editor

Mode

Insert

Inserts rows from the Source File into empty destination tables. If destination tables contain data, the loader returns an error. This error occurs only if a primary key column is defined and this process attempts to insert the same value into a table row.

Replace

Clears and replaces all of the existing rows in the destination tables with the rows from the Source File.

Options

Perform Load

Select this check box to run the DB2 CLIENT IMPORT command automatically after file conversion processing is complete. If you clear this check box, the Load Process prepares the data in the appropriate format and creates the BAT file, but does not initiate the command. To run the command, edit the BAT file to include the proper password information and then run the BAT file.

Delete files if Successful

Select this check box to delete the data files after the DB2 CLIENT IMPORT command completes successfully. If you select this check box, Fast Load Confirmation is unavailable.

Note: Fast Load Confirmation reduces processing time when you run a Load Request that has run before. See Process a Load Request for detailed information.

Delete files if Failure

Select this check box to delete the data files if the process does not complete successfully. If you select this check box, Fast Load Confirmation is unavailable.

Load When Source Is Empty

Select this check box to perform the load if a table to be loaded contains no rows. If you do not select this check box, any tables in the source file containing no rows will be skipped in the load phase.

To create a clean test environment:

• For an existing target table, use
  • Load When Source Is Empty
  • an empty source table
  • Replace mode
• For a newly created table, use
  • Load When Source Is Empty
  • an empty source table,
  • Insert mode

File Type

ASCII

For DB2 for Linux®, UNIX or Windows, use to import data into other DBRM instances or EEE sites.

ASCII Delimited

For DB2 for Linux, UNIX or Windows, use to import data into other DBRM instances or EEE sites. If you select this file type, select a valid delimiter.

iSeries IXF

For a DB2 for i database, use to import data into an iSeries instance.

IXF

For DB2 for Linux, UNIX or Windows, use as the preferred import file type for expedient processing.

Teradata ASCII

For a Teradata loader, use to import data into a Teradata instance. This file type is valid for Teradata Fast Load and Multi Load.

Teradata Delimited

For a Teradata loader, use to import data into a Teradata instance. If you select this file type, select a valid delimiter. This file type is valid for Teradata Fast Load and Multi Load.

Delimiter

To avoid error, the delimiter selected must not appear within the data.

Work path for interim files

Specify a default directory path for storing the temporary loader files.