What is the result of open cursor statement?

0 Answers  

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

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,

---

Which component is used to execute the sql statements?

0 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

How could one combine a set of incremental image copies into a single copy?

1 Answers  

---

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,

---

What is plan in cobol db2?

0 Answers  

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

Where is the access path logic created by the DB2 Optimizer stored?

1 Answers  

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---