Answer Posted / deepak dada

plan contain the package. plan is executable unit. not
package package contains only one dbrm as input and plan
contains nos of dbrm as input .package is more useful than
plan

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

1160

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2389

---

What is schema in db2?

1022

---

Explain db2.

1039

---

What is the difference between using bind () and rebind () methods of naming class?

1401

---

What are union and union all?

983

---

What is cloudant database?

1101

---

What is db2 instance?

1102

---

Explain in detail about buffer manager and its functionalities?

1067

---

What is table space in db2?

1019

---

What is difference between rollback and commit?

1164

---

How to find the number of rows in db2 tables?

1073

---

Is db2 a mainframe database?

1003

---

What is clone table?

1046

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1092

---