Cursor types



IBM's flagship relational database management system

Cursor types

Postby jash » Tue Oct 06, 2009 10:59 am

What are different types of cursor and which one is used frequently.
jash
 
Posts: 12
Joined: Sun Oct 04, 2009 12:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Cursor types

Postby Anuj Dhawan » Tue Oct 06, 2009 12:28 pm

Anuj
Anuj Dhawan
 
Posts: 273
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times

Re: Cursor types

Postby swd » Tue Oct 06, 2009 6:16 pm

I'm not 100% sure what you are asking. If you mean opening a cursor for a) Read Only b) For Update, or perhaps c) With Hold?

Is this what you mean? If it is then they are all used frequently, but it depends what your program is doing. Where I work, all these are commonly used.

If this isn't what you mean then please provide more information.
User avatar
swd
 
Posts: 109
Joined: Wed Feb 18, 2009 9:18 pm
Location: UK
Has thanked: 0 time
Been thanked: 0 time

Re: Cursor types

Postby raghucheepinapi » Thu Oct 08, 2009 1:08 pm

Hi ,

Cursor types are Scrollable and Non scrollable.

Scrollable Cursors are 2 types Sensitive and Insensitive Scrollable cursors.

Raghu.
raghucheepinapi
 
Posts: 3
Joined: Thu Aug 27, 2009 12:35 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post