Can i use scrollable cursor without temporary table?
| 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.