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. |
