Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

where will u check for sqlcode ?

2 Answers   TCS,

---

What is ALTER ?

3 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

How to design maps

1 Answers   Virtusa,

---

What is netezza database?

0 Answers  

---

Mention the various locks that are available in db2.

0 Answers  

---

Where are plans stored?

2 Answers  

---

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  

---

Which transaction use a command thread ?

1 Answers  

---