Troubleshooting Tips: Can BIT columns be mapped to z/os SMALLINT columns (InfoSphere IIG & Unified Governance

The developerWorks Connections platform will be sunset on January 2, 2020. This blog will no longer be available unless an extension has been requested. More details available on our FAQ.

Troubleshooting Tips: Can BIT columns be mapped to z/os SMALLINT columns

madavid Visits (4385)

A bit is described as boolean value to any target (in this case, CDC zos)

The only valid mapping on CDC zos for boolean is to a binary type field. (BINARY, (VAR)CHAR FOR BIT or a (VAR)CHAR field that has been overridden to binary) Valid mappings for boolean are to boolean, binary or BLOB. DB2/zos does not support boolean.

As a workaround, a derived column will achieve the results in cdc zos target

ie. %TONUMBER(%IF(%TOCHAR(column_name,1)='y',0,1))

Blogs

InfoSphere IIG & Unified Governance - News & Troubleshooting Tips by David Ma

About this blog

Related posts

New Jupyter notebook...

Open your doors to O...

Take advantage of yo...

Deliver real time fe...

Db2 Analytics Accele...

Links

Tags

Troubleshooting Tips: Can BIT columns be mapped to z/os SMALLINT columns

Send Email Notification

Quarantine this entry

Mark as Duplicate