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

Db2 for IBM i DBMOVER Statements

Db2 for IBM i DBMOVER Statements

You can include DBMOVER statements specific to Db2 for IBM i data sources.
The following table briefly defines the DBMOVER statements specific to Db2 for IBM i (formerly i5/OS) data sources and provides cross-references to the complete description of the statements:
Statement
Description
Reference
AS400EVENTMSGQ
Specifies an event message queue on an i5/OS system to which PowerExchange writes messages that do not require an operator reply.
AS400USRJRNCODE
Specifies two-character journal entry type codes that identify add library and delete library operations in a DB2 for i5/OS journal. Use this statement to override the default codes that are used for refreshing the CDC library interest list after adding or deleting libraries that contain instances of the same source table.
AS400USRMSGQ
Specifies the message queue on an i5/OS system to which PowerExchange writes messages that require an operator reply.
CAPI_CONNECTION - AS4J
Specifies the Consumer API (CAPI) parameters needed for DB2 for i5/OS CDC sources.
DB2_BIN_AS_CHAR
Controls whether PowerExchange considers data in CHAR and VARCHAR columns that you define with the FOR BIT DATA clause as character data.
DB2_BIN_CODEPAGE
Defines the single-byte and multibyte CCSID values that PowerExchange uses to process character data in columns that you define with the FOR BIT DATA clause, if you specify Y for the DB2_BIN_AS_CHAR statement.
DB2_ERRORFILE
Specifies the name of the user-customized SQL error file that PowerExchange uses for DB2 bulk data movement operations.
IBMI_SUPPRESS_OUTPUT
Suppresses spool file creation for PowerExchange tasks.
IBMI_USE_DB2_SYSTEM_COLUMN_NAMES
Controls whether to use Db2 system column names when performing PowerExchange database row tests and PowerExchange CDC registrations.
QAQQINILIB
Specifies the library name that contains the QAQQINI query options file.
RMTRDBDIRE
Defines the name of the DB2 for i5/OS database on the local system that contains the source tables for CDC in a remote journaling environment.
RMTSYSNAME
Defines the name of the i5/OS host system that contains the DB2 source tables for CDC, local journals, and journal receivers.

0 COMMENTS

We’d like to hear from you!