NOFOR

Causes the SQL Option run-time not to require FOR UPDATE clause in DECLARE CURSOR statements when UPDATE CURRENT OF CURSOR is specified.

Syntax:

[NO]FOR

Parameters:

None

Properties:

Default: FOR

Comments:

If not specified, UPDATE CURRENT OF CURSOR clause will generate a SQL error when statement executed.

You cannot specify FOR explicitly.

Parent topic: XDB Directive Options