Table of Contents


  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. DTLDESCRIBE Metadata
  12. PowerExchange Globalization
  13. Using the PowerExchange ODBC Drivers
  14. PowerExchange Datatypes and Conversion Matrix
  15. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  16. Appendix B: PowerExchange Glossary

Supported WHERE Clauses

Supported WHERE Clauses

The optimized read process supports the following types of SQL WHERE clauses:
  • Conditions that relate key columns to constants. This type of WHERE clause produces a single result when you enter it in a PowerExchange Navigator row test.
  • Conditions that relate key columns to parameters by using the question mark (?) delimiter. This type of WHERE clause produces a set of results for each set of parameters that you supply in a PowerCenter Lookup transformation.


We’d like to hear from you!