Page 1 of 1

removing junk charecter

Posted: Thu Sep 04, 2008 6:01 am
by bikan
Hi,
I am new to the Datastage. I am accessing teradata through server routine, Routine connects to teradata and then executes the SQL , I am exporting result of SQL to file. Problem is in file there are some junk charecters after result. i am calling routine fro m job

select count(*) from EMP is Query
Thanks in ADVANCE

Posted: Thu Sep 04, 2008 7:04 am
by chulett
You need to define what in the heck you mean by 'junk' characters. Be as specific as possible and use a hex editor (or something similar, perhaps 'od') to get the ASCII values for them.