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

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

madavid Visits (1443)

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 & Data Governance - News & Troubleshooting Tips by David Ma

About this blog

Related posts

IBM Tivoli Monitorin...

Best Practice - CDC ...

Why is my CDC so slo...

IBM Tivoli Monitorin...

Recording of "Contin...

Links

Tags

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

Send Email Notification

Quarantine this entry

Mark as Duplicate