FORCE_UPDATABLE_CURSORS option

Function

Controls whether cursors that have not been declared as updatable can be updated.

Allowed values

ON, OFF

Default

OFF

Scope

Can be set temporary for an individual connection for a group, or PUBLIC. Does not require DBA permissions. Takes effect immediately.

Description

When the FORCE_UPDATABLE_CURSORS option is ON, cursors which have not been declared as updatable can be updated. This option allows updatable cursors to be used in front-end applications without specifying the FOR UPDATE clause of the DECLARE CURSOR statement.

Sybase does not recommend the use of the FORCE_UPDATABLE_CURSORS option unless absolutely necessary.