SQL Reference Guide > SQL Reference Guide > D. Settings for Strict ANSI Compliance > ISO_ENTRY_SQL-92 Parameter > Default Cursor Mode
Was this helpful?
Default Cursor Mode
The ANSI Entry SQL-92 standard specifies the default mode for cursors. For details, see Data Manipulation with Cursors on page 249.
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
Last modified date: 01/30/2023