Answer / srini

Declare cursor instead of singleton select,as the query you
are running has multiple records.

Answer / vamsi

use perform statement

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

What is the use of reorg in db2?

0 Answers  

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---

---

What is the use of commit in db2?

0 Answers  

---

B37 abend during spufi?

0 Answers   IBM,

---

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---

What is usage pointer in cobol?

3 Answers   IBM,

---

What is the usage of open cursor command?

0 Answers  

---

What are the four lockable units for DB2?

1 Answers  

---

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,

---