No Auto Result-list (-noautoreslist)

Use No Auto Result-list (-noautoreslist) to avoid building result-lists for static non-scrolling queries.

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

A static non-scrolling query is one that is:

  • Defined using the DEFINE QUERY statement without the SCROLLING option
  • Opened using the OPEN QUERY statement (but not previously defined using the DEFINE QUERY statement)
  • Not associated with a browse widget (and has not been changed into a scrolling query by the DEFINE BROWSE statement)

When you specify this startup parameter, you cannot use the GET PREV, GET LAST, REPOSITION, or BROWSE methods or statements with static non-scrolling queries. If you do, the AVM generates an error. You can use the GET-FIRST( ) method and GET FIRST statement only on newly opened queries, and you can use the GET NEXT statement and GET-NEXT( ) method freely.

If you specify this startup parameter and you open a static non-scrolling query with preselect or sort, the AVM still builds a result-list in order to resolve the query.

Specifying this startup parameter has no affect on dynamic queries, since they are scrolling queries by default.

Specifying this startup parameter can improve the performance of operations on queries.