Managing a cursor is similar to managing a file in a programming language.
See ”Cursor management overview” in SQL Anywhere Server - SQL Usage.
The sp_iqcursorinfo stored procedure displays information about cursors currently open on the server. For more information, see “sp_iqcursorinfo procedure” in Chapter 7, “System Procedures,” in Reference: Building Blocks, Tables, and Procedures.