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 ibm db2 open source?

580

---

What is null in db2?

567

---

How to compare data between two tables in db2?

654

---

On which levels locks can be applied?

651

---

What is db2 purescale?

538

---

---

How do I import data from excel to db2?

607

---

Mention the various locks that are available in db2.

611

---

What is the usage of open cursor command?

596

---

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

694

---

Mention some fields that are a part of sqlca.

592

---

How do we specify index to include or not during bind process.

1670

---

What is load replace in db2?

557

---

Is it possible using max on a char column?

598

---

Explain db2.

605

---

What is the difference between cursor stability and repeatable read isolation levels?

668

---