Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
There is also a considerable difference between declaring a cursor and opening a cursor. . .
how many cursors can be declared in db2
I suspect you mean within one run unit (as opposed to the entire subsystem). . .
Reflect on what you really want to learn and take another shot. . .
As far as i know, there is no limit to the number of cursors specified specified.
As i mentioned, if you have some concern that you will reach some limit, post what you are trying to do with database and someone may have a suggestion. If there is anything being developed that the maximum possible is an issue, suggest a re-design is in order. . .
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
Most of the time when programmers are worried about such limits it is because they doing something the totally wrong way, or they are getting a compile error and are looking a reason other than their own code.