When a table is configure for CCSID 1208 Unicode on the Mainframe DB2 V9, an Insert statement fails with SQLCODE 80 when the data to be inserted are containing special characters like ‘Ä’.

This issue only happens when the value being inserted fills up the column and contains the special characters.

This is due to the fact that special unicode characters are mapped to more chars exceeding the buffer length.

No Fix is available at this time !

Hope this will be fixed in the next major HIS Release 2013.