Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

What is a predicate?

1 Answers  

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

---

How to solved 818 error

4 Answers   Keane India Ltd, Wipro,

---

What is a cursor and what is its function?

2 Answers  

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

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,

---

How to retrieve rows from a db2 table in embedded sql?

0 Answers  

---

What is an inner join, and an outer join ?

1 Answers   CTA,

---