Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

ADABAS_MU_SEARCH Statement

ADABAS_MU_SEARCH Statement

The ADABAS_MU_SEARCH statement specifies whether Adabas multi-value (MU) fields are included in search functions. An MU 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.
z/OS
Adabas
No
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.
Default is N.
  • 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.

0 COMMENTS

We’d like to hear from you!