Answer Posted / sonu

Nice answer!!!!!!!!!!

What is meant by union and union all?

948

---

What is the usage of open cursor command?

1033

---

What is sqlca’s maximum length?

1101

---

Explain about rct in db2?

1043

---

What is nvl in db2?

1039

---

What is a db2 table?

954

---

What is the function of logging in the db2 database?

1068

---

How do you select a row using indexes in db2?

1072

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1017

---

Why do we bind in db2?

1139

---

How can you quickly find out the # of rows updated after an update statement?

984

---

What is the clustering index in the db2 database?

955

---

Differentiate between cs and rr isolation levels? Where do you specify them?

1022

---

What is runstats utility in db2?

961

---

What os does db2 run on?

924

---