Specifies the type of block fetching to use.
Restriction: This topic applies to Windows environments only.
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 |
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.