ASA SQL User's Guide
  Using Procedures, Triggers, and Batches

Using cursors in procedures and triggers

Cursors retrieve rows one at a time from a query or stored procedure with multiple rows in its result set. A cursor is a handle or an identifier for the query or procedure, and for a current position within the result set.

Cursor management overview
Using cursors on SELECT statements in procedures