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

Back Next

{DTLARRAYSIZE= } Escape Sequence

Defines the DB2 fetch array size, in number of rows, for DB2 bulk data movement operations that use the DB2 access method. The array size pertains to the DB2 multiple-row FETCH statements that PowerExchange uses to read data from DB2 source tables.

Valid values are from 1 through 5000. Default is 25.

PowerExchange dynamically lowers the array size when all the following conditions are true:

The database type is DB2.

The table contains LOB columns.

The

Array Size

value is greater than 1.

Row size *

Array Size

is greater than 16000000 bytes.

SQL Escape Sequences

Download Guide

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

{DTLARRAYSIZE= } Escape Sequence

{DTLARRAYSIZE= } Escape Sequence