Can a Db2 table data be retrived through JCL?
Answers were Sorted based on User's Feedback
Answer / kingmanish
Yes ofcourse
Use any of the unload utilities
| Is This Answer Correct ? | 2 Yes | 1 No |
Yes,
That is how we are unloading data from table to dataset.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi...............
Use the Following jcl to retrived the Db2 table data.
//SYSREC00 DD DSN=COOL.UNLOAD.SYSREC02,
// UNIT=SYSDA,SPACE=(32760,(1000,500)),DISP=(MOD,CATLG)
//SYSPUNCH DD DSN=COOL.UNLOAD.SYSPUNC1,
// UNIT=SYSDA,SPACE=(800,(15,15)),DISP=(MOD,CATLG)
//SYSIN DD *
SELECT * FROM SYSIBM.SYSTABLES WHERE OWNER = 'COOL123';
/*
//
THANKS
| Is This Answer Correct ? | 3 Yes | 4 No |
What is DCLGEN ?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
how can i pull up a query which was previously stored in qmf
What is RUNSTATS?
what is datacom db?
What's the difference between DB2 active log and archive log? Thanks a lot...
When do you use the IMAGECOPY?
What is drop table?
pls tell me abt the normalization five types....
how to resolve -811 error. give clear explination
what is the sqlcode -501
What is commit in db2?