Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
can we use BETWEEN predicate in declare Cursor?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
babu_hi

Active User


Joined: 11 Apr 2006
Posts: 59
PostPosted: Wed Apr 30, 2008 1:37 pm    Post subject: can we use BETWEEN predicate in declare Cursor?
 Reply with quote
Can we use predicates in cursor declaration in DB2?
Back to top
View user's profile Send private message
References
PostPosted: Wed Apr 30, 2008 1:37 pm    Post subject: Re: can we use BETWEEN predicate in declare Cursor? Reply with quote
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 2292
Location: italy
PostPosted: Wed Apr 30, 2008 1:38 pm    Post subject: Reply to: can we use BETWEEN predicate in declare Cursor?
 Reply with quote
Why don' t You try and tell us icon_biggrin.gif
Back to top
View user's profile Send private message
Gnanas SNG

Senior Member


Joined: 06 Sep 2007
Posts: 414
Location: India
PostPosted: Wed Apr 30, 2008 2:31 pm    Post subject:
Reply with quote
Yes.
Back to top
View user's profile Send private message
UmeySan

Senior Member


Joined: 22 Aug 2006
Posts: 579
Location: Germany
PostPosted: Wed Apr 30, 2008 4:51 pm    Post subject:
Reply with quote
Yes. ...but spend a little time on performance-aspects, using between.

Regards, UmeySan
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1