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's the best lock size that you could use when you create a tablespace?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
what is a collection?
What is innodb buffer pool?
How can you display the current date & current time ?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
what are extents?
On the create tablespace, what does the CLOSE parameter do?
What is auditing?
What is ibm db2 database?
How do you find the maximum value in a column in db2?