Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers  

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

What is a collection in db2?

0 Answers  

---

What is meant by isolation level?

3 Answers  

---

How can you do the explain of a dynamic sql statement?

0 Answers  

---

wht is d/f between union and joins ?

2 Answers  

---

what is consistency token

3 Answers  

---

Mention the downsides of page level lock.

0 Answers  

---

What is a predicate?

1 Answers  

---

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

0 Answers  

---

What is dbrm library?

0 Answers  

---