Answer / kk

Hi,
-504 is cursor not declared error.may be cursor name
misspeled also coming this error.

Answer / anandrao

There are following possibilities to this issue to come,
1) Cursor is not declared in application program or
in stored procedure depending on where it is used.
Soln - Declare the cursor in application
program or in stored procedure depending on where it is
used.
2) Cursor spelling is not correct which you are
going to open or fetch.
Soln - Check the name used and correct.

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  

---

Explain dclgen.

0 Answers  

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  

---

how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,

---

What is the database descriptor?

2 Answers  

---

What will the DB2 optimizer do?

2 Answers  

---

When do you specify the isolation level? How?

1 Answers  

---

What is a db2 cursor?

0 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

What is buffer pool in the db2 database?

0 Answers  

---