scrollable cursor
Posted: Thu Mar 10, 2011 9:39 pmCan i use scrollable cursor without temporary table?
Thanks
Muralidharan
Thanks
Muralidharan
| 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.
