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

DTLDESCRIBE Qualifiers for DB2 for i5/OS Sources

DTLDESCRIBE Qualifiers for DB2 for i5/OS Sources

The following table lists the DTLDESCRIBE qualifiers for DB2 for i sources:
Field Name
Qualifier 1
Optional, Schema name
Qualifier 2
Optional, Table owner
PowerExchange scans the SQL names of schemas and tables to search for objects when you create a PowerCenter source qualifier or perform a row test, by default. If you set the IBMI_USE_DB2_SYSTEM_OBJECT_NAMES statement in the DBMOVER file to Y, PowerExchange also scans the system object names.


We’d like to hear from you!