IBM Support

Special character failing when loading into Teradata database using the DataStage MQ Connector Stage

Troubleshooting


Problem

Data sent from SAP through MQ has a description 'Black & White Dècor Collection' . While loading the data into a Teradata table (defined as unicode) via a MQ connector, the Datastage job is failing with the error: 'Td_StgItemGroup,0: [IIS-CONN-TERA-005004] RDBMS code 6706: The string contains an untranslatable character' . .

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.7;8.5;8.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM InfoSphere DataStage

Software version:
8.7, 8.5, 8.1

Operating system(s):
AIX, HP-UX, Linux, Solaris

Document number:
207883

Modified date:
25 April 2025

UID

swg21600071

Manage My Notification Subscriptions