Answer / madhavi chava

As definition of cursor is non executable statement, it is
advisable not to define in procedure division as it may
misunderstood others.

we can define it any where only thing you have to take care
is definition of cursor should be prior to the OPEN
statement of the same cursor.

Name some fields from SQLCA

1 Answers  

---

What is the command used by TSO users to invoke DB2?

2 Answers   IBM,

---

What is the difference between spufi and qmf?

0 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,

---

What is the role of the data page in the db2 database?

0 Answers  

---

---

What is filter factor?

2 Answers  

---

What is the use of dclgen in db2?

0 Answers  

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---

What is a db2 schema?

0 Answers  

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---

Mention the downsides of page level lock.

0 Answers  

---