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

PowerExchange Nonrelational SQL Overview

PowerExchange Nonrelational SQL Overview

To access nonrelational sources, such as an IMS database or VSAM file, use the PowerExchange Navigator to create a data map that defines various physical and logical records. PowerExchange accepts a SQL statement in the normal way from the client and passes it to the PowerExchange Listener. The PowerExchange Listener accesses the database and gets the rows. PowerExchange accepts only a subset of the extensive SQL syntax. You must use only the SQL that PowerExchange supports for the SQL requests to be accepted.
The places where you can enter nonrelational SQL include:
  • SQL Statement
    box in the
    Database Row Test
    dialog box
  • Pre SQL
    Post SQL
    session properties for a nonrelational source or target
  • Filter Override
    session property for the source
  • Lookup transformations
  • PowerCenter source qualifier


We’d like to hear from you!