Interested to Buy Any Domain ? << Click Here >> for more details...
Can a Db2 table data be retrived through JCL?
- 4 Answers
- 8579 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 |
How do I connect my db2 database to ibm?
What will happen, while trying to close the closed cursor.
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What is db2 plan table?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
Which component is used to execute the sql statements?
select distinct(empid),distinct(dept),name from EMP will the above query work?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Explain correlated sub-queries.
Can we insert update delete in view?
COBOL 
