Answer Posted / mahyn

However if we want to fetch and process multiple rows
without using cursor, we can do with the below psuedo code.

assume that seq_num is unique.
h-seq initilized with spaces.

perform until sqlcode = +100 or h-seq >= 500
exec sql
select seq_num into :seq-num from tablename
where seq_num > :h-seq
order by Seq_num with ur;
fetch first 1 row only
end-exec
operations
move seq-num to h-seq
end-perform

What is innodb buffer pool?

1132

---

When reorg is used?

1182

---

What is the syntax for FETCH in DB2 ?

1267

---

What is phantom read in db2?

1224

---

What is the difference between dbm cfg and db cfg file in db2 ?

1591

---

What is the use of db2 optimizer?

1175

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1151

---

What does a deadlock mean in DB2?

1217

---

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

1154

---

What is node in db2?

1102

---

What is clone table?

1114

---

What is explain in db2?

1078

---

What is the maximum length of sqlca?

1611

---

What is a Foreign Key?

1139

---

What is database alias db2?

1177

---