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.
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: 08/29/2024