Rocket® Enterprise Developer (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
BLOCKING
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 |
| 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.