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 buffer pool?

1078

---

What is explain plan in db2?

968

---

How do I add a column to a table in db2?

1094

---

How to create backup table in db2?

1072

---

How do you pull up a query which was previously saved in qmf?

1138

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1179

---

Explain about cursor stability?

1025

---

What are the bind parameters ibm db2?

1029

---

Why do we bind in db2?

1196

---

How does a cursor work?

961

---

What do you mean by rollback?

979

---

How would you find out the total number of rows in a db2 table?

1041

---

What are union and union all?

970

---

Highlight all the advantages that are attached to a package.

1101

---

Explain about rct in db2?

1091

---