Embedded SQL programs use the SET SCROLLOPTION, SET CONCURRENCY, SET FETCHBUFFER, and SET CURSOR_CLOSE_ON_COMMIT statements to control cursor options. All other standard cursor behavior is handled automatically by the Embedded SQL library.
Standard cursors use the current database connection. Because standard cursors do not use separate database connections as do browse cursors, many of the locking problems experienced with the use of browse cursors are avoided. Standard cursors also use the cursor functions of DB-Library and will automatically take advantage of any future performance enhancements made to DB-Library cursors.