ADAOPT={N|
Y}

N.
PowerExchange disables optimization and uses L2 commands to read records from files.
Y
.
If you specify Adabas descriptors on the WHERE clause of a SQL SELECT statement, PowerExchange uses L3 commands to read records in logical order from the Adabas file. If the SQL statement does not contain a WHERE clause, PowerExchange uses L2 commands to read records from the file in the physical order in which they were stored by Adabas.
PowerExchange verifies that the Adabas version that is being used supports beginning and ending descriptor key ranges with L3 commands.
If you have installed user modifications to Adabas, PowerExchange might be unable to correctly determine the installed version of Adabas. In this case, you must also specify Y for the ADA_L3_ALLOW statement to use L3 commands.

By default, PowerExchange selects
Ranges Only
in the
Optimization Level
list in data maps. If you select
OFF
in the
Optimization Level
list, PowerExchange ignores this statement and does not use L3 commands when processing data for that data map.
If you specify Y for the ADASTATS statement, PowerExchange writes message PWX-02196 in the PowerExchange message log file. This message indicates whether you can enter L3 commands and the status of optimization.