In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

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 difference between cursor stability and repeatable read isolation levels?

0 Answers  

---

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

What is dynamic SQL?

1 Answers   ADP,

---

What is a DB2 access path?

1 Answers  

---

How do you pull up a query which was previously saved in qmf?

0 Answers  

---

What is a predicate?

1 Answers  

---

Which component is responsible for processing sql statements and selecting access paths?

0 Answers  

---

Where is the output of EXPLAIN stored?

2 Answers  

---