back

ZERO-JCL WAY TO UNLOAD TABLE ROWS AND LOAD THEM UNTO ANOTHER TABLE, IF NECESSARY UNDER A DIFFERENT DB2 SUBSYSTEM AND/OR TABLE CREATOR

  1. Prepare your SQL, and fill in the mandatory fields on the Panel.

(DB2 Subsystem and the Input SQL Dataset Name)

  1. Hit PF6.

 The UNLOADed DATA and PUNCH datasets will be created with relevant data, if LOAD has also been desired, the UNLOADed dataset will be LOADed, along with related reporting.

The UNLOADed DATA and PUNCH datasets name will be reported as:

PJ3.UNLD.DATA.T000650.D030308.T132502    

          AND                             

PJ3.UNLD.PUNCH.T000650.D030308.T132502   

          HAVE BEEN CREATED SUCCESSFULLY.

 among the DISPLAYs of the whole process.