BLOCKING={FSR | SR | LB}
| 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 |
| 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.