Cursor blocking is a technique that reduces overhead by having the database manager retrieve a block of rows in a single operation. These rows are stored in a cache while they are processed. The cache is allocated when an application issues an OPEN CURSOR request, and is deallocated when the cursor is closed. When all the rows have been processed, another block of rows is retrieved.
Use the BLOCKING option on the PREP or BIND commands along with the following parameters to specify the type of cursor blocking:
For more information, see the section on cursor blocking in the Administration Guide.
[ Top of Page | Table of Contents | Glossary | Index ]