FORCE_UPDATABLE_CURSORS Option

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 FORCE_UPDATABLE_CURSORS 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 FORCE_UPDATABLE_CURSORS unless absolutely necessary.