assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

Compare a subselect to a join?

1 Answers  

---

Differentiate between cs and rr isolation levels? Where do you specify them?

0 Answers  

---

How to check last update on table in db2?

0 Answers  

---

What is the result of open cursor statement?

0 Answers  

---

What is the latest version of ibm db2?

0 Answers  

---

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

Define declaration generator (dclgen).

0 Answers  

---

wht r the requirements for writing a cobol-db2 pgm ?

4 Answers   IBM,

---