Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

Datatypes Supported for DB2 for i5/OS Bulk Data Movement

Datatypes Supported for DB2 for i5/OS Bulk Data Movement

PowerExchange supports most DB2 for i5/OS datatypes for bulk data movement.
The following table identifies the DB2 for i5/OS datatypes that PowerExchange supports and does not support for bulk data movement:
DB2 Datatype
Supported for Bulk Data Movement?
BIGINT
Yes
BINARY
Yes
BLOB
Yes (sources only)
BOOLEAN
Yes, as of Db2 for i version V7R5M0
CHAR
Yes
CLOB
Yes (sources only)
DATALINK
No
DATE
Yes
DBCLOB
Yes (sources only)
DECFLOAT
No
DECIMAL
Yes
DISTINCT (user-defined)
No
DOUBLE
Yes
FLOAT
Yes
GRAPHIC
Yes
INTEGER
Yes
LONG VARCHAR
Yes
LONG VARGHAPHIC
Yes
NUMERIC
Yes
REAL
Yes
ROWID
No
SMALLINT
Yes
TIME
Yes
TIMESTAMP
Yes
VARBINARY
Yes
VARCHAR
Yes
VARGRAPHIC
Yes

0 COMMENTS

We’d like to hear from you!