scrollable cursor



IBM's flagship relational database management system

scrollable cursor

Postby muralidharan » Thu Mar 10, 2011 9:39 pm

Can i use scrollable cursor without temporary table?




Thanks
Muralidharan
muralidharan
 
Posts: 13
Joined: Wed Dec 29, 2010 11:19 am
Has thanked: 0 time
Been thanked: 0 time

Re: scrollable cursor

Postby dick scherrer » Fri Mar 11, 2011 3:13 am

Hello,

| TEMP database requirement for static scrollable cursors: To use a static
| scrollable cursor, you must first create a TEMP database and table spaces
| in this database because a static scrollable cursor requires a temporary
| table for its result table while the cursor is open. DB2 chooses a table
| space to use for the temporary result table. Dynamic scrollable cursors do
| not require a declared temporary table.


Suggest you become familiar with the documentation - it is alawys available so there is no waiting on a forum . . .

If you cannot find what you are looking for or it is not clear, then post here and someone should be able to help.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: scrollable cursor

Postby muralidharan » Sat Mar 12, 2011 4:59 pm

thank you for your reply.



Thanks
Muralidharan
muralidharan
 
Posts: 13
Joined: Wed Dec 29, 2010 11:19 am
Has thanked: 0 time
Been thanked: 0 time

Re: scrollable cursor

Postby dick scherrer » Sun Mar 13, 2011 12:45 am

You're welcome :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post