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. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

Example PowerExchange Data Source Specifications

Example PowerExchange Data Source Specifications

The PowerExchange ODBC driver data sources are defined in the ODBC Data Sources section and then the PowerExchange ODBC driver parameters are set in the individually named section.
For example the
infadb2
data source parameters are defined in the [
infadb2
] section:
[ODBC Data Sources] infadb2=INFA PWX850 DB2 infanrdb=INFA PWX850 NRDB loaddb2=INFA PWX850 DB2LOAD oracleunicode=INFA PWX850 UNICODE [infadb2] DRIVER=/usr/powerexchange/bin/libdtlodbc.sl DESCRIPTION='Descriptive Text for DB2 Data Source section' DBTYPE=db2 LOCATION=db2 DBQUAL1=dsn1 [infanrdb] DRIVER=/usr/powerexchange/bin/libdtlodbc.so DESCRIPTION='Freeform text for nrdb section' DBTYPE=nrdb LOCATION=laptop [infanrdb2] DRIVER=/usr/powerexchange/bin/libdtlodbc.so DESCRIPTION='Freeform text for nrdb2 section' DBTYPE=nrdb2 LOCATION=node1 [loaddb2] DRIVER=/usr/lw/stprod310/libdtlodbc.so DESCRIPTION=LoadDB2 DBTYPE=DB2 LOCATION=RemoteLOC (From DBMOVER.CFG) DBQUAL1=SSID (target database SSID) BULKLOAD=Y CTLTEMPLATE=DB2LDCTL JCLTEMPLATE=DB2LDJCL DELETETEMPFILES=2 (BEFORE) FNAME=INFA.V310.ODBC LOADOPTIONS=4 (REPLACE) MODETIME=1 (WAIT) MODETYPE=3 (JOB) PRISPACE=1 SECSPACE=1 SPACE=t TIME=0 [oracleunicode] DRIVER=/dtlqa2/v850/libdtlodbcu.so DESCRIPTION= DATABASE= DBTYPE=ORACLE LOCATION=tortilla DBQUAL1=TO101UTF MAXROWS=0 COMPRESS=N ENCRYPT=N CONFIRMWRITE=N PACESIZE=0 INTERPRETASROWS=N BULKLOAD=N DELETETEMPFILES=0 LOADOPTIONS=0 LOCALCODEPAGE=41 MODETYPE=0 MODETIME=0 TIME=0
If no ODBC Driver Manager is installed, you can use the one provided with the PowerExchange software. This code is provided as libdtlodbcinst.so or libdtlodbcinst.sl (HP only) so as not to impact any existing ODBC Driver Manager. To use this code, you must either:
  • Rename it to libodbcinst.so or libodbcinst.sl (HP only).
  • Create a hard or symbolic link to it as libodbcinst.so or libodbcinst.sl (HP only).