Interested to Buy Any Domain ? << Click Here >> for more details...
Can a Db2 table data be retrived through JCL?
- 4 Answers
- 8792 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 |
Explain the benefits you can get from mainframe connect?
What is meant by isolation level?
When is the skeleton cursor table created?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
How many buffer pools are available in db2?
How connect db2 database to datastage?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
how to unload different table data into different gdg files/ vsam files.
Why do we use cursor?
What are the various locking levels available?
Q3. How will you fetch duplicate values from a DB2 table?
Where is the access path logic created by the DB2 Optimizer stored?
COBOL 
