Junk characters

arnie_nits · Post by **arnie_nits** » Wed Feb 02, 2011 5:29 am

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

chulett · Post by **chulett** » Wed Feb 02, 2011 9:18 am

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.

greggknight · Post by **greggknight** » Sun Feb 20, 2011 9:53 am

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?