This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

What is a system catalog table in db2?

0 Answers  

---

What is concurrency in db2?

1 Answers  

---

What's The Percentage Free Space ?

0 Answers   IBM,

---

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

---

What are common abends

1 Answers   SPIC, Virtusa,

---

What is the database descriptor?

2 Answers  

---

What does it mean if the null indicator has -1, 0, -2?

1 Answers  

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 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,

---

Explain correlated sub-queries.

0 Answers  

---