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

Explain the function of data manager.

1050

---

If I have a view which is a join of two or more tables, can this view be updateable?

1139

---

What is copy pending status in db2?

1128

---

can all users have the privilage to use the sql statement select * (dml)?

1177

---

What is declare cursor?

1127

---

What is the information associated with sysibm.syslinks table?

1130

---

Is db2 a database?

984

---

What is a trigger in the db2 database?

1091

---

What is runstats db2?

1042

---

What is innodb buffer pool?

1063

---

Give the name of some fields form sqlca.

1091

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3158

---

What is sqlca?

1083

---

What is scrollable cursor in db2?

1059

---

When reorg is used?

1137

---