IBM Mainframe Forum

by **muralidharan** » Thu Mar 10, 2011 9:39 pm

Can i use scrollable cursor without temporary table?

Thanks
Muralidharan

by **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.

by **muralidharan** » Sat Mar 12, 2011 4:59 pm

thank you for your reply.

Thanks
Muralidharan

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

You're welcome

d

IBM Mainframe Forum

scrollable cursor

scrollable cursor

Re: scrollable cursor

Re: scrollable cursor

Re: scrollable cursor