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
UDB
|
| VARCHAR FOR BIT (Treat as CHARACTER) |
IBM i
UDB
|
| clob (uni) | Not Supported |
| GRAPHIC | string |
| VARGRAPHIC | string |
| dbclob (uni) | Not Supported |