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

Oracle DBMOVER Statements

Oracle DBMOVER Statements

You can include DBMOVER statements specific to Oracle data sources.
The following table briefly defines the DBMOVER statements specific to Oracle data sources and provides cross-references to the complete description of the statements:
Specifies the CAPI parameters to use for PowerExchange Express CDC for Oracle sources.
Specifies the name of the user-customized SQL error file that PowerExchange uses for Oracle bulk data movement operations.
Specifies that PowerExchange Express CDC for Oracle is the CDC solution to use for a PowerExchange installation.
Controls whether PowerExchange handles the following types of numeric columns in Oracle source tables in a manner that prevents data loss:
  • NUMBER columns that have a precision greater than 28 or an undefined length
  • FLOAT columns that have a precision greater than 15 significant digits
Specifies the PowerExchange and PowerCenter code pages to use for a specific Oracle database used in Oracle bulk data movement, if the NLS_LANG environment variable specifies a character set other than UTF8 or AL32UTF8.
Specifies the Oracle source database and connection information for PowerExchange Express CDC for Oracle.


We’d like to hear from you!