Default Cursor Mode
The ANSI Entry SQL-92 standard specifies the default mode for cursors. For details, see
Data Manipulation with Cursors (see page
Data Manipulation with Cursors).
ANSI/ISO Entry SQL-92
Direct mode:
dbmsinfo('db_direct_update') returns Y
dbmsinfo('db_deferred_update') returns N
Ingres Default
Deferred mode:
dbmsinfo('db_direct_update') returns N
dbmsinfo('db_deferred_update') returns Y