Data Type Mapping for Db2 for Linux, Unix and Windows - DSS 6 | Data Source Solutions Documentation
Documentation: Data Type Mapping for Db2 for Linux, Unix and Windows - DSS 6 | Data Source Solutions Documentation
Data Type Mapping for Db2 for z/OS
This section lists the mapping of data types for Db2 for z/OS.
Db2 for z/OS as Source
When Db2 for z/OS is used as a source location, following is the mapping of data types in Db2 for z/OS to the corresponding Data Source Solutions DSS repository data type.
| Db2 for z/OS | Capture Support | Repository Data Type |
|---|---|---|
| smallint | Native | smallint |
| integer | Native | integer |
| bigint | Native | bigint |
| decimal | Native | decimal |
| decfloat | Native | decfloat |
| real | Native | real |
| double | Native | double |
| date | Native | ansidate |
| time | Native | time2 |
| timstamp without time zone | Native | timestamp |
| timestamp with time zone | Native | db2 timestamp with time zone |
| char | Native | char |
| varchar | Native | varchar |
| clob | Native | clob |
| binary | Native | binary |
| blob | Native | blob |
| varbinary | Native | varbinary |
| dbclob | Native | nclob |
| graphic | Native | nchar |
| vargraphic | Native | nvarchar |
| xml | Native | db2 xml |
| rowid | Not Supported |
Db2 for z/OS as Target
When Db2 for z/OS is used as a target location, following is the mapping of DSS repository data types to the corresponding data type in Db2 for z/OS.
Text in green cell indicates the native data type of the DBMS
{% partial file="dss6/advanced-operations/data-type-mapping/db2-for-z-os.template.md" /%}