connector does not support data transfer in Unicode format

[Salegueule]

Hi,

We are using a server job that reads data using a hashfile and two plug-in; one is DB2 reading a dashDB (IBM Bluemix) database and the other using the ODBC stage reading a Paraccel database.

We are receiving the following warning:

Code: Select all

"The connector does not support data transfer in Unicode format. When reading column OPERATOR, data will be converted to UTF-8 and then converted to Unicode. The conversion to UTF-8 can cause data loss or corruption."

We used a similar just in the past with no problems reading Paraccel and a real DB2 database. Sounds like the problem is induced by reading dashDB that is using UTF8 by default.

The problem seems to be similar to another post here. Is it possible that the fix is not included in DS 9.1?

I have tried to removed the project default NLS mapping of UTF8; changed the char-varchar to nchar-nvarchar; add the extended Unicode property for char-varchar columns and the warning is still there. Any suggestion is welcome.

Thanks.

[Salegueule]

Hi,

I did resolved the warning issue by simply replacing the DB2 UDB connector by the oldest version of DB2 UDB API one.