DB2 Explain

SCROLL vs NO SCROLL Cursors in DB2

By default, cursors are moved by 1 row at a time in the result table in sequential order starting from the first row. To remove this limitation SCROLL clause is used to indicate whether the cursor moves sequentially through the result table or can move randomly through the result table. You can declare row-positioned or […]

SCROLL vs NO SCROLL Cursors in DB2 Read More »