I am using Dynamic RDBMS (DRS) Stage to access source SQL Server database.
Source table is having Decimal, Varchar, Timestamp data type fields.
I am writing it to Sort--->RemoveDuplicate Satge---->DataSet stage.
While running the Job its giving the following warning messages
Dynamic_RDBMS_0,0: Illegal character conversion found converting from UTF-8.
Could anyone figure out this warning, what it is.
Thanks
DRS Stage throwing Warning
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
DRS Stage throwing Warning
Regards
VS
VS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If using NLS, try using a map of NONE to see what happens. Otherwise there seems to be a difficulty in handling NChar or NVarChar; try using Char or VarChar instead (and, perhaps, using CAST in your SELECT statement (column definitions)).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.