Missing delimter and non ascii characters in the file
Posted: Fri Oct 02, 2009 10:45 am
Hi Everyone,
I have job which reads from dataset ,loads in to a sequential file . The options i have set in the sequential file are
Final Delimter -- end
record delimiter- unix new line
delimeter - pipe
date format string, timestamp format string ( iam converting the date and timestamp format ). The job is running fine but when i view the data on the unix file system i see pipe delimiter is missing for some fields and also wierd characters.
00003010038144|^D218912140020|^B29R|||03/14/2008|12/31/9999|D|V|D|Y|Active|20091002:103630
But the record should looks like
00003010038144|2189|12140020|29|R|||03/14/2008|12/31/9999|D|V|D|Y|Active|20091002:103630.
Could anyone please let me know the reason for missing delimter between coulmns and wierd characters.
Thanks in Advance
I have job which reads from dataset ,loads in to a sequential file . The options i have set in the sequential file are
Final Delimter -- end
record delimiter- unix new line
delimeter - pipe
date format string, timestamp format string ( iam converting the date and timestamp format ). The job is running fine but when i view the data on the unix file system i see pipe delimiter is missing for some fields and also wierd characters.
00003010038144|^D218912140020|^B29R|||03/14/2008|12/31/9999|D|V|D|Y|Active|20091002:103630
But the record should looks like
00003010038144|2189|12140020|29|R|||03/14/2008|12/31/9999|D|V|D|Y|Active|20091002:103630.
Could anyone please let me know the reason for missing delimter between coulmns and wierd characters.
Thanks in Advance