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 db2 purescale?

949

---

Define predicate?

1073

---

What is the use of dclgen in db2?

1021

---

What is catalog database in db2?

1109

---

Where do you specify them?

1180

---

What is netezza database?

966

---

Who uses db2?

988

---

How is deadlock resolved?

1089

---

What is the role of data manager in the db2 database?

1058

---

Mention some fields that are a part of sqlca.

982

---

Is schema the same as database?

1014

---

What is the result of open cursor statement?

1036

---

What is database reorganization?

1066

---

What is explain in db2?

972

---

What is a bind in db2?

996

---