The ADAOPT statement is an Adabas optimization statement that controls whether PowerExchange uses Adabas L3 commands to read records from a file in logical sequence by descriptor value.
ADA_L3_ALLOW, and ADASTATS
PowerExchange disables optimization and uses L2 commands to read records from files.
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.
Default is Y.
By default, PowerExchange selects
list in data maps. If you select
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.