FORCE_UPDATABLE_CURSORS option

Function

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

Allowed values

ON, OFF

Scope

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

Default

OFF

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.