Preface
Introduction to PowerExchange
- PowerExchange Overview
- PowerExchange Components
DBMOVER Configuration File
Netport Jobs
PowerExchange Message Logs and Destination Overrides
- PowerExchange Message Logs
  - PowerExchange Message Log File
  - PowerExchange Alternative Log Files
    - Determining the Size of the Alternative Log Data Sets on z/OS
    - Allocation Options for Alternative Log Data Sets on z/OS
- PowerExchange Message Destination Overrides
  - DTLMSGO File and Statements
SMF Statistics Logging and Reporting
PowerExchange Security
Secure Sockets Layer Support
PowerExchange Alternative Network Security
PowerExchange Nonrelational SQL
DTLDESCRIBE Metadata
- DTLDESCRIBE Metadata Overview
  - DTLDESCRIBE Metadata Syntax
  - DTLDESCRIBE Qualifiers
PowerExchange Globalization
Using the PowerExchange ODBC Drivers
PowerExchange Datatypes and Conversion Matrix
- PowerExchange Datatype Conversions
- ODBC and PowerExchange Datatype Equivalencies
Appendix A: DTL__CAPXTIMESTAMP Time Stamps
- Time Stamps That Are Reported in the DTL__CAPXTIMESTAMP Field by Data Source
Appendix B: PowerExchange Glossary
- Glossary of Terms

Reference Manual

10.5.6
- 10.5.5
- 10.5.4
- 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 ODBC Driver Overview

PowerExchange provides thin ODBC drivers that PowerCenter and other clients can use to connect to a data source through PowerExchange.

To define a PowerExchange ODBC data source on Linux or UNIX, edit the odbc.ini file.

To define a PowerExchange ODBC data source on Windows, use the

Windows ODBC Data Source Administrator

PowerExchange also defines SQL escape sequences that you can use to override PowerExchange defaults when you connect to a data source by using a PowerExchange ODBC driver.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

PowerExchange ODBC Driver Overview

PowerExchange ODBC Driver Overview