Embedded SQL/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 returns only one row. This behavior is illustrated in COBOL samples, example3.pco and example4.pco.
Embedded SQL/COBOL scrollable cursors are read-only with INSENSITIVE or SEMI_SENSITIVE properties. example3.cpo shows usage of an INSENSITIVE scrollable cursor; example4.cpo shows usage of a SEMI_SENSITIVE scrollable cursor.
The existing cursor declare statement and the fetch statement have been enhanced for this new feature.
