Previous Topic Next topic Print topic


BLOCK

Specifies the record blocking mode to be used on package creation. For information about row blocking, see the IBM DB2 Administration Guide or the Application Programming Guide.

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.
Previous Topic Next topic Print topic