BLOCKING

Specifies the type of block fetching to use.

Syntax:

BLOCKING={FSR | SR | LB}

Parameters:

block-code The code for type of block fetching to perform when program is statically bound:
FSR (Forced Single Row) does not use block fetching regardless of cursor type
SR (Single Row) uses block fetching for read-only cursors and fetches a row at a time for ambiguous cursors
LB (Limited Block) uses block fetching for read-only and ambiguous cursors
Default: LB

Properties:

Default: LB

Comments:

This directive only has meaning when program has been statically bound.

Multiple collection-ids are only supported when doing AUTOBIND, Collection-ids must be delimited by a semi-colon with no spaces in the string. A maximum of 10 collection-ids are supported but the same number of DBRMs must be specified or the number of collection-ids greater than DBRMs will be ignored. Also, you must specify at least one collection-id or a compile error SQL0335 will be generated when using multiple binds.