Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

---

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

---

What is cursor?

2 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

Can you access the DB2 Directory table using SQL?

3 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

---

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---