Generating Unload Control Statements

The next step is to generate the unload control statements. These statements are used to unload data from the tables. Users can also specify the names of the data sets that are used as destinations for unloading the tables. Otherwise, Data Compare uses data sets with names generated in the manner described in Specifying the Unload Data Sets.
carcudb2
The next step is to generate the unload control statements. These statements are used to unload data from the tables. Users can also specify the names of the data sets that are used as destinations for unloading the tables. Otherwise, Data Compare uses data sets with names generated in the manner described in Specifying the Unload Data Sets.
Specifying Unload Data
 
To generate the unload control statements, enter
U
in the Sel (Selection) field next to the selected table pair on the Data Compare Explode Services panel and press Enter.
After entering the Unload Data line command, the Data Compare Unload Generation screen displays.
Generate Statements to Unload Data
 
The Data Compare Unload Generation screen controls the generation of the unload statements, which unload data from the source or target tables.
Notice that there are no unload control statements yet for the source or target table.
To generate statements to unload data from the source or target tables, complete the fields on the Data Compare Unload Generation screen as follows and press Enter.
  • Specify
    Y
    in the Generate field.
  • Specify the table(s) for which the unload statements are to be generated in the Tables field.
The unload statements for the specified tables will be displayed in the middle and bottom of the data display area, respectively.
Each set of unload control statements can be scrolled independently: use F7 (Up) and F8 (Down) for the source table unload statements, and use F10 (Left) and F11 (Right) for the target table unload statements. Press F3 (End) to save the statements and return to the Data Compare Explode Services panel. Press F3 again to save the strategy and return to the Data Compare Strategy Services screen. After the unload statements have been generated, the data can be unloaded.
Options for Unloading Table Data
 
Before comparing table data, it must be unloaded from the tables. If unsure whether data has been unloaded, check the unloaded data, using the technique described in the Viewing Unloaded Data.
To unload the data, select a Compare Strategy with the A or the B option on the Data Compare Strategy Services screen. Option A allows the user to unload data and proceed directly into the data comparison. Option B only allows the user to unload the data. Option A is discussed in Unloading and Comparing Table Data.
Data Compare Unload Specification Screen
 
Option
B
on the Data Compare Strategy Services screen displays the Data Compare Unload Specification screen.
On the Data Compare Unload Specification screen, specify whether the statements are being created for unloading the source, target, or both tables.
Unloading the Data
Once the unload process has been started, the Data Compare Confirmation screen appears. It displays the unload statements. Scroll through the commands using F7 (Up) and F8 (Down). From the Data Compare Confirmation screen, F3 (End) cancels the unload and displays the previous screen. Press Enter to unload the data. After the data has been unloaded, the Audit Message File displays return codes and unload messages. Press F3 (End) to return to the Unload Specification screen.