Reference Manual

10.5.4
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

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