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

What is a collection in db2?

1092

---

What are the benefits of using the db2 database?

1288

---

What do you mean by cursor?

1030

---

Explain in detail about buffer manager and its functionalities?

1139

---

How to rename a table in DB2 ?

1145

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1150

---

Are view updateable?

1091

---

List down the data types in the db2 database.

1179

---

What is the latest version of ibm db2?

1335

---

What is db2 and what is the use of db2 optimizer?

1110

---

What is the maximum length of sqlca?

1610

---

How to execute stored procedure in db2 command editor?

1098

---

What is syscat in db2?

1070

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1157

---

What are iseries servers?

1130

---