Hi............... Use the Following jcl to retrived the Db2 table data.

Can a Db2 table data be retrived through JCL?

Question Posted / mr. cooooool

4 Answers
8424 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What is innodb buffer pool?

975

How can the duplicate values be eliminated from db2 select?

1039

How to execute stored procedures?

1059

What is the role of schema in the db2 database?

1179

What is the latest version of ibm db2?

1198

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1102

Explain about open switch business continuity software?

1070

Which component is used to execute the sql statements?

1052

What is view db2?

1004

What is dbrm? When it will be created?

956

define clustering index.

975

What is host variable?

1011

What is alias in db2?

980

Where do you specify them?

1161

What is the syntax for FETCH in DB2 ?

1136