Load - SQL Insert

The following figure is displayed when you specify Load Option 1, in the File-AID Load for DB2 in the Extract File Specification screen.

LOAD - SQL Insert

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.

Mode

Displays the current execution mode of the load request, either BATCH (default) or ONLINE. Use the MODE primary command to switch from one mode to the other.

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. 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.

Specify Discard Processing Options

Discard processing is available when loading with Load Method Db2 SQL Insert.

Save Discarded Rows

Specify whether or not to save rows, or records, that could not be inserted or updated.

Y	Save rows that cannot be inserted or updated in the discard file.
N	Do not save rows that cannot be inserted or updated.

Maximum Rows to Discard

Specify the maximum number of errors encountered before processing stops. Specify an asterisk (*) for no maximum or a value greater than 0. Specify 1 if you want processing to stop if any errors are encountered. Specify YES in the Save Discarded Rows field to save these rows for future use. The discard file need not exist to specify a value in this field.

File for Discarded Rows

Specify the name of the file to which discarded rows will be saved. The discard file must be sequential. If you specify YES in the Save Discarded Rows field and specify a file that does not exist, File-AID for Db2 will display the Create New File screen.

The discard file can be used as input to the load process if a previous load job was completed normally, but rows were discarded. See Reusing-the-Discard-File.

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. With ONLINE mode enabled, File-AID shows the generated REXX panel where you review the load REXX. See also View REXX.

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.

MODE

Enter the MODE command to switch the load execution mode from BATCH (default) to ONLINE or from ONLINE back to BATCH. MODE acts as a toggle switch. MODE command is only valid when variable ALLOW_LOADS_TO_RUN_ONLINE is set to Y. For more information, see ALLOW_LOADS_TO_RUN_ONLINE in the SVC information.