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

CAPX Properties Tab

CAPX Properties Tab

On the
CAPX Properties
tab in the
PowerExchange Data Source
wizard, enter properties to define a PowerExchange CAPX data source.
Extract Type
The extraction type. The options are:
  • SL
    . Start the extraction from the point where the last extraction ended, either by restart tokens for z/OS, or by checkpoint timestamps for i5/OS.
  • RS
    . Restart the extraction from the start point of the last extraction. This option enables you to run the same extraction multiple times.
Corresponding ODBC Parameter: CAPXTYPE
Image Type
The capture image type. The options are:
  • BA
    . Captures the before image data, before the latest change, and the after image data, after the latest change. The before image data is shipped with an action character forcing the deletion of the record. The after image data, which includes the change data, is in the format of an insert operation.
  • AI
    . Captures the after image data only.
  • TU
    . Captures the before and after image data, as it occurs. The before image data enables the application to ensure that no changes occurred in the record since the request. The after image data appears as an update operation. The update is a full image, but the application that captures this change can change the target record rather than delete it and insert a new record, as occurs with a BA.
Corresponding ODBC Parameter: CAPXIMAGETYPE
AS400 Library/Filename
Overrides the fully qualified DB2 for i5/OS library and table name specified in the PowerExchange capture registration.
For example:
Corresponding ODBC Parameter: DBQUAL1
AS400 Instance
Overrides the name of the DB2 for i5/OS instance specified in the PowerExchange capture registration.
Corresponding ODBC Parameter: DBQUAL2
CAPI Connection
Overrides the default database connection specified in CAPI_CONNECTION statement in the DBMOVER configuration file.
To point to the relevant data source, specify the value in the NAME parameter of the CAPI_CONNECTION statement in the DBMOVER configuration file.
Corresponding ODBC Parameter: DTLCONN_OVR
Extraction Schema
Overrides the schema name specified in an extraction map.
Maximum length is 128 characters. No spaces are allowed.
Corresponding ODBC Parameter: XTRASCHEMA


We’d like to hear from you!