MFSET - Multi-Fetch Setting

#### Search Results

Search

# MFSET - Multi-Fetch Setting

This Natural profile parameter specifies whether multi-fetch (see MULTI-FETCH Clause) is used to retrieve records from Adabas databases.

Possible settings | `NEVER` | Always use single-fetch.
`OFF` | Use single-fetch as default. This can be overwritten on statement level.
`ON` | Use multi-fetch as default. This can be overwritten on statement level.
Default setting | `OFF` |
Dynamic specification | yes |
Specification within session | no |