Db2 for IBM i source to Avro target - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

The table displays the mapping for Db2 for IBM i as a source to Avro as a target.

Db2 for IBM i Avro
bigint long
BLOB Not Supported
CLOB Not Supported
Double double
float float
date string
integer int
numeric float
DECIMAL float
real float
smallint int
time string
timestamp string
CHAR FOR BIT (Treat as CHARACTER)

IBM i

  • GRAPHIC. (Unicode)

  • VARGRAPHIC. (Unicode)

UDB

  • GRAPHIC. (Unicode)

  • VARGRAPHIC. (Unicode)

    Supported targets can be unicode or non-unicode.

VARCHAR FOR BIT (Treat as CHARACTER)

IBM i

  • GRAPHIC. (Unicode)

  • VARGRAPHIC. (Unicode)

UDB

  • GRAPHIC. (Unicode)

  • VARGRAPHIC. (Unicode)

    Supported targets can be unicode or non-unicode.

clob (uni) Not Supported
GRAPHIC string
VARGRAPHIC string
dbclob (uni) Not Supported