Learn how to use a cursor in SQL DB2 stored procedures to process multiple rows of data from a query result set. Find out how to declare, open, fetch, close, and deallocate a cursor.

The cursor example above produces 11114 logical reads from the database. The following snippet performs the same operation as the cursor above but through the use of a WHILE loop.

> This feature will be removed in a future version of Windows. Avoid using this feature in new development work and plan to modify applications that currently use this feature. Microsoft recommends ...