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 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:
Statement
Description
Reference
CAPI_CONNECTION - ORAD
Specifies the CAPI parameters to use for PowerExchange Express CDC for Oracle sources.
ORA_ERRORFILE
Specifies the name of the user-customized SQL error file that PowerExchange uses for Oracle bulk data movement operations.
ORACLE_CAPTURE_TYPE
Specifies that PowerExchange Express CDC for Oracle is the CDC solution to use for a PowerExchange installation.
ORACLE_UNHANDLED_NUMASCHAR
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
ORACLECODEPAGE
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.
ORACLEID
Specifies the Oracle source database and connection information for PowerExchange Express CDC for Oracle.

0 COMMENTS

We’d like to hear from you!