A cursor is a data selector that passes multiple rows of data to the host program, one row at a time. The cursor indicates the first row, also called the current row, of data and passes it to the host program. With the next fetch statement, the cursor advances to the next row, which has now become the current row. This continues until all requested rows are passed to the host program.
Use a cursor when a select statement returns more than one row of data. Client-Library tracks the rows Adaptive Server returns and buffers them for the application. To retrieve data with a cursor, use the fetch statement.
The cursor mechanism is composed of these statements:
declare
open
fetch
update and delete where current of
close
