What is a Database Request Module(DBRM)?

4 Answers  

---

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

3 Answers   Valtech,

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

What is view db2?

0 Answers  

---

where can we use index and subscript ? with example ?

3 Answers   CTS,

---

Are view updateable?

0 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

how can you access index

4 Answers   IBM, Tech Mahindra,

---

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 precompiler in db2?

0 Answers  

---

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

2 Answers  

---

what is sql abend code -801,-802?

2 Answers  

---