RAMESH KRISHNA REDDY mainframe discussion forum - cobol, db2,cics,jcl,file-aid,changeman,... interview questions, quizs
Online Tutorials 



DRONA SERIES
IKJEFT01




Quick Start on IKJEFT01 utility



   
 

Quick Start on IKJEFT01 Utility
1) Unload data using DB2 Utility IKJEFT01
2) DB2 BIND using IKJEFT01 Utility
3) Executing DB2 program using IKJEFT01 Utitlity.





1) IKJEFT01 can be used to extract data from db2 tables. as shown below. JCL to extract data from db2 tables using IKJEFT01 Utility.

//STEP002  EXEC PGM=IKJEFT01,                                         
//             DYNAMNBR=20,COND=(0,NE)                                  
//STEPLIB  DD  DISP=SHR,                                                
//             DSN=SYS.DB2.XXX.RUNXX.LOAD                            
//         DD  DISP=SHR,                                                
//             DSN=SYS.DB2.XXX.SDSNEXIT                               
//         DD  DISP=SHR,                                                
//             DSN=SYS.DB2.XXX.SDSNLOAD                               
//SYSIN    DD  *                                                        
   SELECT  *                                             
   FROM EMP_TABLE
   WITH UR;                                                            
//*                                                                     
//SYSTSIN  DD  *                                                        
    DSN SYSTEM(XXX) RETRY(20)                                            
    RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) PARMS('SQL') -                   
       LIB ('SYS.DB2.XXX.RUNXX.LOAD')                                 
    END                                                                   
/*                                                                      
//***UNLOAD FILE                                                        
//SYSREC00 DD  DISP=(NEW,CATLG,DELETE),                                 
//             DSN=DEV.UNLOAD.FILE,              
//             UNIT=SYSDA,SPACE=(CYL,(50,50),RLSE)                      
//*                                                                     
//***TABLE STRUCTURE                                                    
//SYSPUNCH DD  DUMMY
//*                                                                     
//SYSTSPRT DD  SYSOUT=*                                                 
//SYSPRINT DD  SYSOUT=*                                                 
//SYSUDUMP DD  SYSOUT=*                                                 

2) Using IKJEFT01 utility for DB2 BIND Sample JCL to DB2 BIND
//*  DB2 BIND JCL
//*
//BIND     EXEC PGM=IKJEFT01,                                           
//             COND=(4,LT),                                             
//             REGION=4096K                                             
//STEPLIB  DD  DISP=SHR,                                                
//             DSN=XXX4.DB2.XXXX.XXXXLOAD                               
//DBRMLIB  DD  DISP=SHR,                                                
//             DSN=DEV.SURESH.DBRM(DB2PROG)    <---------------  (1)        
//SYSPRINT DD  SYSOUT=*                                                 
//SYSTSPRT DD  SYSOUT=*                                                 
//SYSUDUMP DD  SYSOUT=*                                                 
//SYSTSIN  DD  *                                                        
DSN SYSTEM (DEVDB	)                                                       
BIND  MEMBER    (DB2PROG) -                                             
      PACKAGE   (PACKG11) -                                            
      LIBRARY   ('DEV.SURESH.DBRM') -         <---------------- (2)                        
      ACTION    (REP) -                                                 
      ISOLATION (CS) -                                                  
      VALIDATE  (BIND)-                                                 
      RELEASE   (COMMIT) -     
      OWNER     (SURESH) -                                             
      QUALIFIER (DEVQUALI)                                               
END                                                                     
/*                                                                      
(1) & (2) - specify the location of DBRM. It is a part of cobol db2 compile jcl.. Refer COBOL DB2 program compile JCL 3) Using IKJEFT01 utility for executing cobol db2 program. Sample JCL to execute IKJEFT01 utility to run COBOL DB2 program.
//** COBOL DB2 RUN JCL 
//STEP01 EXEC PGM=IKJEFT01,                                              
//         DYNAMNBR=20                                                  
//*                                                                      
//STEPLIB  DD  DISP=SHR,                                                
//             DSN=SYSL.DB2.DEV.XXXXLOAD                                
//         DD  DISP=SHR,                                                
//             DSN=SYSL.DB2.DEV.XXXXYYYY    
//*                                                                      
//SYSTSPRT DD  SYSOUT=*                                                  
//SYSTSIN  DD  *                                                        
DSN SYSTEM(DEVDB)                                                        
  RUN PROGRAM(DB2PROG)              - 
      PLAN(PLAN11111)                      -                        
      LIBRARY('DEV.SURESH.LOADLIB')            
      END                                                                    
/*                                                                      
//SYSOUT   DD  SYSOUT=*                                                  
//SYSIN    DD  *                                                        
//*                      
//* COBOL DB2 RUN JCL ENDS              
    
DO You need Technical Help on DB2 or IKJEFT01 or ON jcl : Click here to go to Mainframe Discussion Forum


DB2 Tutorial   Download DB2 E-book   db2 interview questions

                                   




Home | Online Tutorials | Books | Entertainment | Contactme | privacy |  sql tutorial | jcl interview questions | JCL Tutorial | JCL Tutorial - chapter1 | JCL Tutorial - chapter2 | JCL Tutorial - chapter3 | JCL Tutorial - chapter4 | JCL Tutorial - chapter5 | JCL Tutorial - chapter6 | JCL Tutorial - chapter7 | JCL Tutorial - chapter8 | JCL Tutorial - chapter9 | JCL Tutorial - chapter10 | JCL Tutorial - chapter11