Answer Posted / ram g

if u r talking about host language app pgm its not
posssible dats d reason we are hving cursor logic...
in select stmt its quite possible by having condtn in whr
clause such a way it can fetch multiple record..

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

1139

---

Which component is responsible for processing sql statements and selecting access paths?

1122

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2320

---

Is db2 a mainframe?

1039

---

What is the maximum number of columns in a db2 table?

1275

---

Can there be more than one cursor open for any program?

1161

---

What is buffer pool and list some of them?

1017

---

is it compulsory commitment control in journal?

2472

---

What are db2 objects?

1041

---

What is the maximum size of varchar data type in db2?

1125

---

What is load replace in db2?

989

---

How can you count the number of rows from a table tab?

1083

---

What is a system catalog table in db2?

1182

---

What is node in db2?

1038

---

What is coalesce in db2?

1124

---