What is index cardinality?

3 Answers  

---

how do you resolve -805?

3 Answers   HCL,

---

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

---

What is netezza database?

0 Answers  

---

What is a dbrm in db2?

0 Answers  

---

when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,

---

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

---

How can you get the number of rows impacted by the last executed query?

1 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

how to take the back up of the DB2 table.

7 Answers  

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---

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,

---