Apply the SCROLLING option to all DEFINE QUERY STATIC statements in order to create client-side result lists. This option improves performance when query results are received over a network. However, performance is reduced if there is no networking.

Operating system and syntax UNIX / Windows -defaultscrolling
Use with Maximum value Minimum value Single-user default Multi-user default
Client Session — — — —

When the SCROLLING option is enabled for DEFINE QUERY STATIC statements, the server can pack multiple records in a single network message. This is known as prefetching. Prefetching allows for repositioning to other records in the result set on the client side rather than on the server side. Therefore, prefetching can significantly reduce network traffic.

Note:
  • -defaultscrolling is a run time startup parameter and does not affect the source code compilation.
  • If there is a sort or preselect operation, the -defaultscrolling startup parameter only affects the presort pass, when the rowids and sort fields are collected.
  • The -noautoreslist startup parameter conflicts with -defaultscrolling. If both parameters are specified, a runtime error results.