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

Explain in brief how does db2 determine what lock-size to use?

1034

---

What is access path in db2?

978

---

What are host variables in db2?

1043

---

What is null value in db2?

1012

---

what is the role of the cursor in db2?

1060

---

What is buffer pool in the db2 database?

1083

---

What is a bind card?

1210

---

List some fields from sqlca?

1049

---

what is utility for parm lib

2365

---

What is runstats utility in db2?

1016

---

Name the various locking levels available?

1087

---

What are packages in db2?

1019

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2379

---

What is the max length of sqlca?

1210

---

Is db2 a mainframe?

1036

---