The csr_disp_scrollcurs2.c sample program uses a scrollable cursor to retrieve data from the authors table in the pubs2 database:
Sends a query to the server to open a cursor.
Processes the results using the standard ct_results while loop.
Binds the column values to program variables.
Fetches the rows using ct_scroll_fetch and displays them.
This example requires Adaptive Server version 15.0 or
later, with scrollable cursor support, and the pubs2 database.
This example uses a scrollable cursor with arrays as program variables and array binding. A single ct_scroll_fetch call displays results in an array.
This is the query:
select au_fname, au_lname, postalcode
from authors
