Can a Db2 table data be retrived through JCL?

Question Posted / naliniknayak@gmail.com

4 Answers
7134 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can a Db2 table data be retrived through JCL?..

Answer / srikant

yes

Is This Answer Correct ?

4 Yes

3 No

Can a Db2 table data be retrived through JCL?..

Answer / kingmanish

Yes ofcourse

Use any of the unload utilities

Is This Answer Correct ?

2 Yes

1 No

Can a Db2 table data be retrived through JCL?..

Answer / azharuddinsyed

Yes,

That is how we are unloading data from table to dataset.

Is This Answer Correct ?

0 Yes

0 No

Can a Db2 table data be retrived through JCL?..

Answer / mr. cooooool

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

Post New Answer