Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---

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  

---

what are the bind parameters?

5 Answers   IBM,

---

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

---

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  

---

---

what is a corelated subquerry?

0 Answers   IBM,

---

How to restart a DB2 program?

0 Answers   Cognizant,

---

What are union and union all?

0 Answers  

---

How do I add a column to a table in db2?

0 Answers  

---

What is a storage group (stogroup)?

0 Answers  

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

How to create backup table in db2?

0 Answers  

---