Load - DB2 Load

The following figure is displayed when you specify Load Option 2, in the Load Option field of the Extract File Specification screen.

LOAD - DB2 Load

Use this screen to specify the target table to be loaded with the data from the extract file as well as load processing options. After specifying the load target and processing options you can issue the EDIT command to view the generated load JCL before submitting the job, or the GO command to execute the generated JCL and have File-AID for Db2 load the target table.

Extract File

Identifies the name of the File-AID for Db2 extract file from which you want to load data.

Source Table

Displays the fully qualified name of the source object from which data was extracted.

Specify Table to Load Area

SSID

Specify the name of the Db2 subsystem to which Db2 data will be loaded. If you leave the Location field blank, the table you specify to be loaded must exist in the Db2 subsystem displayed in this field.

Location

Specify the location of the table you want to load if it is in a remote Db2 subsystem. The location you enter must be defined in the Db2 system catalog table SYSIBM.LOCATIONS. You must use the SQL Insert Load Option to use the remote location.

Leave this field blank if the table you want to load resides in the Db2 subsystem displayed in the target SSID field.

Creator

Specify the creator ID of the target table. This field is prefilled with the extracted source creator ID.

Table Name

Specify the name of the target table. This field is prefilled with the extracted source table name.

Specify Processing Options Area

Delete all existing data

Specify whether or not File-AID for Db2 should delete ALL of the data residing in the target table before it loads data from the extract file. For Db2 tables, Db2 delete rules are in effect.

Y	File-AID for Db2 deletes all rows from the specified table before loading data.
N	Indicates that the data is to be loaded into the table without deleting existing rows.

Replace duplicate keys

When you are adding data to a table that is not empty and the INSERT operation fails because the row or record already exists, specify whether or not it should be replaced.

Y	If the target Db2 table has a unique index, data from the extract file will replace existing data in the target table.
N	If the target table has a unique index and an existing target row has a unique key that matches the data from the extract file, the data from the extract file will be discarded. If the target table does not contain a unique index and rows to be loaded already exist, no data will be discarded.

Commit Every Nth Row

Specify the number of rows File-AID for Db2 should insert or update before it performs a Db2 COMMIT. This value must be less than or equal to the value specified for the Max Commit Interval installation parameter.

Primary Commands

The following File-AID-specific primary command is valid on this screen:

EDIT (E)

Displays the JCL for this load request. File-AID shows the Generated JCL panel where you review and modify the load JCL. See also Edit JCL.

GO (G)

Submits this load request. Before issuing the GO command, make sure you have completed all the load information. File-AID will also issue a message upon completion of the job.