Interested to Buy Any Domain ? << Click Here >> for more details...
Can a Db2 table data be retrived through JCL?
- 4 Answers
- 8778 Views
- I also Faced
- E-Mail Answers
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 precompiler in db2?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
When is the results table for the query in a DECLARE CURSOR statement created?
how to unload different table data into different gdg files/ vsam files.
What is ACQUIRE/RELEASE in BIND?
What are the disadvantages of using VARCHAR?
What is a dbrm in db2?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
how to fetch first 100 rows in db2
Where is the output of EXPLAIN stored?
What are simple, segmented and partitioned table spaces ?
COBOL 
