Explain what a plan is?

3 Answers   CTS,

---

How to restart a DB2 program?

0 Answers   Cognizant,

---

What is deadlock?

2 Answers  

---

what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---

---

List down the data types in the db2 database.

0 Answers  

---

What is check constraint. Explain with example.

0 Answers  

---

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers   MCN Solutions,

---

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,

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---

What do you need to do before you do EXPLAIN?

1 Answers  

---