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. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

IBMI_USE_DB2_SYSTEM_COLUMN_NAMES

IBMI_USE_DB2_SYSTEM_COLUMN_NAMES

Optional. Controls whether to use Db2 system column names when performing PowerExchange database row tests and PowerExchange CDC registrations.
This statement pertains to PowerExchange Navigator personal metadata, CDC database row tests, PowerExchange CDC registrations for both the Navigator and the DTLUCBRG utility. It also pertains to PowerCenter Db2 for IBM i and CDC source and target imports and PowerCenter CDC workflows.
IBM i
No
IBMI_USE_DB2_SYSTEM_COLUMN_NAMES=(Y|
N
)
  • Y
    . Use Db2 system column names. When you specify Y, the system column name is displayed for CDC row tests and PowerExchange CDC registrations in the PowerExchange Navigator and DTLUCBRG utility.
  • N
    . Use long column names. Do not use Db2 system column names.
Default is
N
.