I'm using the DB/2 connector to read varchar columns from a database table.
NLS is set to UTF8.
I get a warning with the message id IIS-CONN-DAAPI-000395.
The message says that the connector doesn't support data transmission in unicode format.
Is there any possibility to get rid of this warning?
I've implemented the same functionality in a parallel job and there I don't get this warning.
DB/2 connector warning with unicode
Moderators: chulett, rschirm, roy
Re: DB/2 connector warning with unicode
Hi tbrosi
first of all there is no such thing as "DB/2" it is a full database so it is DB2
I have Server Jobs working without problems in DataStage 8.5 (both with UTF-8 Job NLS setting and without).
Which DataStage version do you use?
What is the database codepage - UTF-8?
first of all there is no such thing as "DB/2" it is a full database so it is DB2
I have Server Jobs working without problems in DataStage 8.5 (both with UTF-8 Job NLS setting and without).
Which DataStage version do you use?
What is the database codepage - UTF-8?
regards
Michael
Michael
Hi tbrosi
I do not have a DataStage 8.7 at hand ...
What could be interstiong though is if you expect unicode characters or not. Or in other word does the problem occur as well when you select the let us say tabname from syscat.tables?
Have you tried using the UNICODE extended attribute in the column definitions?
best regards
Michael
I do not have a DataStage 8.7 at hand ...
What could be interstiong though is if you expect unicode characters or not. Or in other word does the problem occur as well when you select the let us say tabname from syscat.tables?
Have you tried using the UNICODE extended attribute in the column definitions?
best regards
Michael
regards
Michael
Michael
Hi tbrosi
finally I remember this problem - sorry we had it in 2011 so I forgot about it but when I read you last message I finially remembered it.
We had the same problem in DS 8.5 and a PMR was opened and we got a special build for this.
Please check for APAR JR39943
You might open a PMR in order to get the fix for DataStage 8.7 but at least the problem is known and fixed in DS 8.5.
best regards
Michael
finally I remember this problem - sorry we had it in 2011 so I forgot about it but when I read you last message I finially remembered it.
We had the same problem in DS 8.5 and a PMR was opened and we got a special build for this.
Please check for APAR JR39943
You might open a PMR in order to get the fix for DataStage 8.7 but at least the problem is known and fixed in DS 8.5.
best regards
Michael
regards
Michael
Michael