By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

unload data

P: n/a
I 'm using DB2 ver6,I want to transfer data from DB2 tables to dataset at
OS390,how can I do it?
regards

--
Message posted via http://www.dbmonster.com
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
What's your source platform?

Larry Edelstein

shabnam via DBMonster.com wrote:
I 'm using DB2 ver6,I want to transfer data from DB2 tables to dataset at
OS390,how can I do it?
regards

Nov 12 '05 #2

P: n/a
it 's OS390,
I submit this JCL but it doesn't work:

-------------------
//JOB1 JOB TLOAD,JOBNAME,MSGCLASS=T,CLASS=1
//*
//JOBLIB DD DSN=DSN610.DSNLOAD,DISP=SHR
//UNLOAD EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAU6) LIB('DSN610.RUNLIB.LOAD')
//*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//*DATA
//SYSREC00 DD DSN=JOB.UNLOAD,DISP=(,CATLG,DELETE),
// UNIT=SYSDA,SPACE=(CYL,(1,1)),DCB=BUFNO=20
//*CONTROL CARD
//SYSPUNCH DD DSN=JOB.LISTCARD,DISP=(,CATLG,DELETE),
// UNIT=SYSDA,SPACE=(TRK,(1,1),RLSE)
//SYSIN DD *
JOB.TABLENAME
------------------

--
Message posted via http://www.dbmonster.com
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.