Embedded SQL/C 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 Embedded C samples, example4.pc and example5.pc.
Embedded SQL/C scrollable cursors are read-only with INSENSITIVE or SEMI_SENSITIVE properties. example4.cp shows usage of an INSENSITIVE scrollable cursor; example5.cp shows usage of a SEMI_SENSITIVE scrollable cursor.
The existing cursor declare and fetch statements are enhanced for this new feature.
