ESQL/COBOL now supports scrollable cursors, which allow you to set the current cursor position anywhere in the result set by specifying the fetch orientation. Both single row fetches and multiple row fetches are supported. By default, if the row count is not set at cursor open time, a fetch will return only one row. This default behavior is illustrated in COBOL samples example3.pco and example4.pco.
Scrollable cursors are read-only with INSENSITIVE or SEMI_SENSITIVE properties. Two new samples are included for the feature: example3.cp shows usage of an INSENSITIVE scrollable cursor; example4.cp shows usage of a SEMI_SENSITIVE scrollable cursor.
For more information on scrollable cursor support, refer
to “Open Server support for scrollable cursors”, “Embedded SQL/C scrollable cursors”, and “Scrollable cursors supported”.
The following sections describe ESQL/COBOL statements that have changed due to the introduction of scrollable cursors.
