D. Settings for Strict ANSI Compliance : ISO_ENTRY_SQL-92 Parameter : Default Cursor Mode
 
Share this page                  
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