|
View previous topic :: View next topic
|
| Author |
Message |
vinay249
New User
Joined: 18 Apr 2007
Posts: 13
Location: Bangalore
|
|
|
|
Hi,
Please provide me the JCL for copying the data from DB2 tables to the Dataset.
Thanks in Advance, |
|
| Back to top |
|
 |
Naresh Kumar Reddy P
New User
Joined: 24 May 2007
Posts: 8
Location: Bangalore
|
|
|
|
Vinay,
You can use IKJEFT01 utility for copying the data from a DB2 table to mainframe dataset. You can give the DB2 query in SYSIN as the input, and the output dataset with the DD name SYSREC00.
Let us know for any issues.
Thanks
Reddy |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Vinay,
You may use below JCL, with a little modification.
JCL is written with IKJEFT01, as stated earlier.
| Code: |
//JOBCARD
//*
/*ROUTE XEQ DB2P
//*
//STEP000 EXEC UCC11RMS,PARM=F
//*
//STEP030 EXEC PGM=IKJEFT01,
// DYNAMNBR=20,
// REGION=4M
//*
//STEPLIB DD DSN=DB2SYS1.VEND.LOADLIB,
// DISP=SHR
//*
//SYSREC00 DD DSN=HLQ.OUT.FILE
// DISP=(NEW,CATLG,DELETE),
// UNIT=SYSDA
//*
//SYSPUNCH DD SYSOUT=*
//*
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2P)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) -
PARM('SQL')
/*
//*
//SYSIN DD *
YOUR QUERY STATEMENT
/*
//* |
|
|
| Back to top |
|
|
|
|
