Interested to Buy Any Domain ? << Click Here >> for more details...
Can a Db2 table data be retrived through JCL?
- 4 Answers
- 8662 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 the error code -803 ?
What is a DB2 bind?
Which component is responsible for processing sql statements and selecting access paths?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is temporal table in db2?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
Q3. How will you fetch duplicate values from a DB2 table?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How many buffer pools are there in DB2?
Define declaration generator (dclgen).
How do I copy a table in db2?
How and when does the db2 enforces the unique key?
COBOL 
