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

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

madavid Visits (3099)

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

Db2 Analytics Accele...

Welcome to WCE Pract...

How to retrieve data...

IBM Tivoli Monitorin...

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