Answer Posted / 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.

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

1010

---

What is data manager?

1009

---

How can record locking be achieved in those DB2 versions which do not support it?

1038

---

List out the three types of page locks that can be held.

1114

---

What is temporal table in db2?

1002

---

How to run db2 command in windows?

1158

---

What is declare cursor?

1076

---

What is the difference between using bind () and rebind () methods of naming class?

1355

---

What are the various isolation levels possible?

1074

---

what is diffrence b/w file-aid tool and file-aid utility???

4840

---

What is null indicator in db2?

1062

---

What r the comman abends in db2, jcl and cobol???????

2223

---

How does coalesce work?

979

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4258

---

can we view the access paths created by dbrm ? how ? thx

7013

---