DSXchange

Hi,

A junk character '�' sometimes get attached in front of varchar fields.
Like 'Datastage' loaded as '�Datastage'

How can I remove it in the job.

Regards,
Arnie

First order of business is to identify it, you can't properly deal with something if you don't know what it is. Check via a hex editor or the UNIX 'od' command or via the appropriate sql command, depending on where this is happening.

That is the varchar size indicator which is placed in the front of a varchar field.
You will see those if you look at the file in an editor but not from within the view data in the seq stage.

I had the same thing when I am using the CDC and dropping the data down from DB2 with datamirror to a text file. Which I processed from DS.

Are they causing a specific issue?