DRS Stage throwing Warning

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
satish_valavala
Participant
Posts: 123
Joined: Wed May 18, 2005 7:41 am
Location: USA

DRS Stage throwing Warning

Post by satish_valavala »

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
Regards
VS
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
Post Reply