File-AID Load for Db2

This section describes Option 2 - File-AID Load for DB2 . The Load option is used to load data from the File-AID extract that was created using File-AID-Extract-for-Db2 into a table.

Important

You cannot use this option to load data from an extract created with a File-AID for Db2 release prior to 6.1, or with the File-AID for Db2 legacy option Option 3 - Extract from a Table to a Data set, or from a delimited file format extract.

The Load option consists of an interactive phase and an execution phase.

The interactive phase takes place online and consists of a File-AID for Db2 Load panel that allows you to provide information about the following:

  • The DASD extract file from which to load data.
  • The target object.
  • Db2 LOAD or SQL Insert processing options.

Using this information, File-AID for Db2 builds a series of steps to be performed during the execution phase. You can then edit and save the load JCL created by File-AID for Db2 before you submit it. Your installation may also permit interactive (online) execution of the load.

During the execution phase, you can load data into existing objects that contain data or load it into empty objects. When loading into Db2 objects you have the choice of using either IBM’s Db2 LOAD utility or SQL INSERT processing.

You can delete all existing data before loading, replace existing rows with records from the extract file, or leave existing rows intact, only adding rows to the object.

File-AID for Db2 verifies user authority before performing certain operations. See Db2-Privileges for more information.

This section provides information about the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*