Extract and load options
The Extract and Load Options screen displays when you select option 5 from the Extract/Load menu (Extract/Load Menu). This option allows you move tables from one location to another smoothly.
To use this option, the target table must already exist and the target table must be identical in definition to the source table. Column matching is not supported.
The only new screen used for option 5 is the Extract and Load Options screen.
Extract and Load Options Screen
From Table Area:
Location ID
Location of the table from which to copy. If the subsystem is local, this field can be left blank.
Creator
ID of the person who created the Db2 table. Enter an asterisk (*) for a selection list.
Table Name
Name of the Db2 table, synonym, view or alias from which data is extracted. Enter an asterisk (*) for a selection list.
To Table Area
Location ID
Location of the table to which to copy. If the subsystem is local, this field can be left blank.
Creator
ID of the person who created the Db2 table. Enter an asterisk (*) for a selection list.
Table Name
Name of the Db2 table, synonym, view or alias to which data is copied. Enter an asterisk (*) for a selection list.
Processing
After this initial screen, processing follows the normal path. The screens all base upon previous screens in the series, just as in normal processing, except that information in the Load screens is now based upon previous Extract screens. Which screens are accessed will depend on whether you selected batch or online as your processing mode:
Online
- Extract Options screen (Extract Options Screen)
- Extract Selection Template (Extract Selection Template)
- Extract Table screen (Extract Table Screen)
- Extract Confirmation (Extract Confirmation Screen)
- Extract Summary Report (Extract Confirmation Screen)
- Load Table screen (Load Table Screen)
- Load Confirmation screen (Load Confirmation Screen)
- Load Summary Report screen (Detailed Load Report: Summary Window Information).
Batch
- Extract Options screen (Extract Options Screen)
- Extract Selection Template (Extract Selection Template)
- Extract Table screen (Extract Table Screen)
- Extract Confirmation (Extract Confirmation Screen)
- Load Table screen (Load Table Screen)
- Load Confirmation screen (Load Confirmation Screen)
- JCL to submit.