Can a Db2 table data be retrived through JCL?
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 physical storage length of the data types: date, time, timestamp in the db2 database?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
How to solve S0C7 abend with out using DISPlay in 10 mins?
Which are the db2 tools to protect integrity of the database?
how will you retrieve first record in table
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
can we update the table by using cursors can anyone post the query?
What is load replace in db2?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What is image copy?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
What is the use of COMMAREA ?Minimum how much data we can pass from it?