Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
cursors in db2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
bhuspin

New User


Joined: 13 Aug 2008
Posts: 26
Location: chennai

PostPosted: Thu Dec 03, 2009 10:48 am    Post subject: cursors in db2
Reply with quote

Can anyone tell me how many cursors can be declared in db2
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Dec 03, 2009 10:52 am    Post subject:
Reply with quote

Hello,

You will probably get more useful replies if you explain what you want to do. . .
Back to top
View user's profile Send private message
bhuspin

New User


Joined: 13 Aug 2008
Posts: 26
Location: chennai

PostPosted: Thu Dec 03, 2009 10:59 am    Post subject:
Reply with quote

i want only the count , just to know
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6970
Location: porcelain throne

PostPosted: Thu Dec 03, 2009 12:36 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Dec 04, 2009 3:21 am    Post subject:
Reply with quote

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
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Fri Dec 04, 2009 5:47 am    Post subject:
Reply with quote

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
View user's profile Send private message
neontech
Warnings : 1

New User


Joined: 08 Dec 2009
Posts: 11
Location: mumbai

PostPosted: Tue Dec 08, 2009 11:00 am    Post subject: how many cursors can be declared in db2
Reply with quote

You can have as cursors many cursors as you want in a DB2 cobol program.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Handling multiple cursors in cobol - ... Thirumurgann DB2 5 Thu Sep 15, 2011 8:02 am
No new posts DB2 Select without using cursors in E... dick scherrer CA Products 3 Mon Aug 22, 2011 2:39 pm
No new posts How to Insert multiple Rows into Db2 ... dick scherrer DB2 2 Wed Jul 27, 2011 1:49 pm
No new posts Ques reagrding cursors Amb DB2 2 Fri May 27, 2011 1:08 pm
No new posts DB2 Cursors arun nehra DB2 3 Tue Jun 15, 2010 3:26 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us