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
  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. DTL__CAPXTIMESTAMP Time Stamps
  15. 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
    and
    Post SQL
    session properties for a nonrelational source or target
  • Filter Override
    session property for the source
  • Lookup transformations
  • PowerCenter source qualifier