|
View previous topic :: View next topic
|
| Author |
Message |
bhuspin
New User
Joined: 13 Aug 2008
Posts: 26
Location: chennai
|
|
|
|
| Can anyone tell me how many cursors can be declared in db2 |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
You will probably get more useful replies if you explain what you want to do. . . |
|
| Back to top |
|
|
bhuspin
New User
Joined: 13 Aug 2008
Posts: 26
Location: chennai
|
|
|
|
| i want only the count , just to know |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| Quote: |
| Can anyone tell me how many cursors can be declared in db2 |
actually you can't declare a cursor in db2.
you declare a cursor in a program.
can anyone tell me if there has been a less technically qualified question this week? (month? year?)
26 posts and you are asking questions like this. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
There is also a considerable difference between declaring a cursor and opening a cursor. . .
| Quote: |
| 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. . . |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
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. |
|
| Back to top |
|
|
neontech
Warnings : 1
New User
Joined: 08 Dec 2009
Posts: 11
Location: mumbai
|
|
|
|
| You can have as cursors many cursors as you want in a DB2 cobol program. |
|
| Back to top |
|
|
|
|
