Previous Topic Next topic Print topic

BLOCK

Syntax:

BLOCK={UNAMBIG | ALL | NO}

Parameters:

ALL Specifies blocking for read-only cursors or cursors not specified as FOR UPDATE OF. Ambiguous cursors are treated as read-only.
NO Specifies no blocking of any cursors. Ambiguous cursors are treated as updateable.
UNAMBIG Specifies blocking for read-only cursors or cursors not specified as FOR UPDATE OF. Ambiguous cursors are treated as updateable.

Properties:

Default: BLOCK=UNAMBIG
Synonym: BLOCKING.
Parent topic: DB2 Compiler Directive Options
Previous Topic Next topic Print topic