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.
Posts: 12
Joined: Sun Oct 04, 2009 12:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Cursor types


Re: Cursor types

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

Anuj Dhawan
Posts: 274
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
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.

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

Return to DB2


  • Related topics
    Last post