You can specify the following new statement in the DBMOVER configuration member:
ADABAS_MU_SEARCH={Y|
N
}
New
. Enables PowerExchange to include Adabas multiple-value fields in SQL search and selection operations. A multiple-value field is a single field that occurs a variable number of times in a record. The MU field name is prefixed with a $ symbol and is allowed in searches. The MU field must be an Adabas descriptor field. It appears as type MU in an Adabas record description. Options are:
Y
. PowerExchange uses multiple-value Adabas descriptor fields in searches. If you specify a multiple-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 multiple-value fields in searches.
Default is N.
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.
For more information, see the "DBMOVER Configuration File" chapter in the