Controlling Adabas Multifetch for Join Operations

You can use the FETCHJOIN command to take advantage of Multifetch efficiencies in Join operations for a session. This feature is particularly useful when you are joining to a base file in which sorting is based on the key field that is used for the join.

Syntax: How to Set Adabas FETCHJOIN

ENGINE ADBSINX SET FETCHJOIN {ON|OFF}

where:

ADBSINX: Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
ON: Sets the FETCHJOIN feature on for the user session. ON is the default value.
OFF: Sets the FETCHJOIN feature off for the user session. This value is recommended when joining with a base file that is unsorted by the key field used for joining. This option avoids buffering and reduces processing time.