Prepare Mainframe Data

Here, you UNLOAD the sample table, DSN8910.EMP, using Micro Focus Rumba+ Desktop to create and submit the appropriate JCL.

1. From your Windows desktop, start the Rumba+ Desktop.
2. In the Create New Session group, click Mainframe Display.
3. Click Connection > Connect to start a mainframe session.
4. In the Application field, type TSO; then press Return.
5. Type your mainframe user ID; then press Return.
6. In the Password field, type your mainframe password; then press Return.
7. In the Option field, type 2; then press Return.
8. In the Member field of the Edit Entry Panel, type EMPDEMO to create the JCL; then press Return.
9. Code the JCL required to unload the data from the DSN8910.EMP table using DSNUTILB, and to download the LOAD control statement. For example, here you use the following z/OS mainframe job where the mainframe user is MFIXCH:

   //MFIXCH02 JOB (DB2JOB),'DB2 JOB',REGION=4M,    
   //     CLASS=A,MSGCLASS=X,MSGLEVEL=(1,1) 
   //UNLOAD1  EXEC PGM=DSNUTILB,REGION=0M,PARM='DB9R,MFIXCH' 
   //STEPLIB  DD DSN=DSN910.SDSNLOAD,DISP=SHR
   //SYSREC   DD DSN=MFIXCH.UTILBTS.SYSREC1,                           
   //       DISP=(MOD,CATLG),                            
   //       UNIT=SYSDA,SPACE=(CYL,(1,1))     
   //SYSPUNCH DD DSN=MFIXCH.UTILBTS.PUNCH1,    
   //       UNIT=SYSDA,SPACE=(TRK,(1,1)),DISP=(MOD,CATLG) 
   //SYSPRINT DD SYSOUT=* 
   //UTPRINT  DD  DUMMY 
   //SORTOUT  DD  UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) 
   //SYSDISC  DD  DUMMY
   //SYSERR   DD  UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)                  
   //SYSMAP   DD  UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)                  
   //SYSUT1   DD  UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)                  
   //SYSIN    DD *                                                         
   UNLOAD DATA FROM TABLE DSN8910.EMP                                      
   /*                                                                      
   //

10. To save and submit your JCL, enter SAVE into the Command field, and then enter SUB into the Command field.