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.3
- 10.5.5
- 10.5.4
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

DTLDESCRIBE Qualifiers for DB2 for i5/OS Sources

The following table lists the DTLDESCRIBE qualifiers for DB2 for i sources:

Field Name	Explanation
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.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

DTLDESCRIBE Qualifiers for DB2 for i5/OS Sources

DTLDESCRIBE Qualifiers for DB2 for i5/OS Sources