Step 2. Load the DB2 table

The second step loads the DB2® table.
Figure 1. Export Step 2. Load DB2 table
  File  Options  Help                                                      
-----------------------------------------------------------------------
                             Export HDB Data Set                           
Command ===> __________________________________________________________
                                                                           
Select option                                                  
1  1. Create DDL to define table        Start of change3. Upgrade table to current versionEnd of change
   2. Load data into table

Create Options                          Load Options                       
_  Create Database                      1  1. Resume                       
_  Create Storage Group                    2. Replace                      
 
Start of changeUpgrade Settings:                                                 
⋮End of change                                                                           
Select option 2 Load data into table.
The generated JCL is displayed in an edit session for review and submission.
Figure 2. Edit JCL to load DB2 table
EDIT       SYB.SPFTEMP3.CNTL                               Columns 00001 00072 
Command ===> SUB_____________________________________________ Scroll ===> PAGE 
****** ***************************** Top of Data ******************************
000001 //SYB#CPA JOB ,NOTIFY=&SYSUID                                          
000002 //* CICSPA V5R3 HDB - LOAD DATA INTO DB2 TABLE                         
000003 //DSNUPROC EXEC PGM=DSNUTILB,REGION=0M,                                
000004 //         PARM='DB2P'                                                 
000005 //STEPLIB  DD  DISP=SHR,DSN=DB2.PROD.SDSNLOAD                          
000006 //         DD  DISP=SHR,DSN=DB2.PROD.SDSNEXIT                          
000007 //SYSPRINT DD  SYSOUT=*                                                
000008 //UTPRINT  DD  SYSOUT=*                                                
000009 //SYSUDUMP DD  SYSOUT=*                                                
000010 //SYSREC   DD  DSN=SKU.#180203.D05049.T182306.HDB,                     
000011 //             DISP=SHR                                                
000012 //         DD  DSN=SKU.#180203.D05049.T182311.HDB,                     
000013 //             DISP=SHR                                                
000014 //         DD  DSN=SKU.#180203.D05049.T182316.HDB,                     
000015 //             DISP=SHR                                                
000016 //SYSUT1   DD  UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)                 
000017 //SORTOUT  DD  UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)                 
000018 //SYSIN    DD  *                                                       
000019 LOAD DATA RESUME YES                                                   
000020    INTO TABLE CICSPA.HST014B WHEN (70) = '014B' (                      
000021       START_DATE            POSITION(1)      DATE EXTERNAL(10),        
000022       START_TIME            POSITION(12)     TIME EXTERNAL(8),         
000023       APPLID                POSITION(20)     CHAR(8),                  
000024       MVSID                 POSITION(28)     CHAR(4),                  
000025       DSA_NAME              POSITION(77)     CHAR(8),                  
000026       DSA_LOCATION          POSITION(85)     CHAR(8),                  
000027       ACCESS                POSITION(93)     CHAR(8),                  
000028       DSA_INDEX             POSITION(101)    CHAR,                     
000029       DSA_SIZE_CUR          POSITION(102)    INTEGER,                  
000030       DSA_SIZE_PEAK         POSITION(106)    INTEGER,                  
000031       CUSHION_SIZE          POSITION(110)    INTEGER,                  
000032       GETMAIN_REQUESTS      POSITION(114)    INTEGER,                  
. . .