ADABAS_MU_SEARCH={Y|
N} 

Y.
PowerExchange uses multi-value Adabas descriptor fields in searches. If you specify a multi-value field in a WHERE clause of an SQL SELECT statement, PowerExchange scans the field for values specified in the search.
N
.
PowerExchange will not include Adabas multi-value fields in searches.

In an existing data map definition, the field name for a multi-value descriptor (DE) field can be used by adding the $ prefix to the multi-value field name and eliminating the subscripting index.
Limit search criteria that includes multi-value fields to an EQUAL comparator or a BETWEEN phrase. Complex searches using an OR comparator or non-descriptor search values are not supported. The following SELECT statements show simple search criteria for multi-value fields:
SELECT * from 
table_name where $MU_field = 'JONES' 
SELECT * from 
table_name where $MU_field >=  10 and $MU_field <= 20 
SELECT * from 
table_name where $MU_field is between 10 and 20
SELECT AA_field, AB_field, $MU_field where $MU_field = 10
The multi-value field can also be used in a SQL SELECT statement if the field was used in the search criteria. The SQL SELECT statement presents the contents of the multi-value array data that meets the search criteria.
If you set the ADABAS_MU_SEARCH statement to Y, make sure that the ADAOPT statement is also set to Y to use L3 commands to read records from file in logical sequence by descriptor value. If the search cannot be optimized, and there are OR criteria in the SQL, the search will fail.