Interested to Buy Any Domain ? << Click Here >> for more details...
Can a Db2 table data be retrived through JCL?
- 4 Answers
- 8654 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 cobol picture clause of the db2 data types date, time, timestamp?
How do I add a column in db2?
Why select is not preferred in embedded sql programs?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
Comment whether the cursor is closed during commit or not.
How will fetch last 5 rows from table in db2
How do you stop a db2 database in linux?
What is a bind card?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
My SQL is not performing well. Describe how will you fine tune it?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
What is a NULL value? What are the pros and cons of using NULLS?
COBOL 
