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 the physical storage length of timestamp data type?

0 Answers  

---

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

What is blu acceleration in db2?

0 Answers  

---

What is the function of the Data Manager?

2 Answers  

---

Why cursor is used in db2?

0 Answers  

---

How to check last update on table in db2?

0 Answers  

---

What is a storage group (stogroup)?

0 Answers  

---

How many databases are there?

0 Answers  

---

Explain the EXPLAIN statement?

1 Answers  

---