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
Junk characters
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 120
- Joined: Thu Oct 28, 2004 4:24 pm
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?
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?
"Don't let the bull between you and the fence"
Thanks
Gregg J Knight
"Never Never Never Quit"
Winston Churchill
Thanks
Gregg J Knight
"Never Never Never Quit"
Winston Churchill