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
Missing delimter and non ascii characters in the file
Moderators: chulett, rschirm, roy
You can move it over to your desktop and use a hex editor or from the UNIX side try an "od -h" on the file and post the results. There are many free hex editors out there to try. For the "od" command, probably best to use it on a file with just that one record in it, if possible.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi,
below are the hex values for the above one record
0000000 3030 3030 3330 3130 3033 3831 3434 7c00
0000020 0432 3138 3931 3231 3430 3032 307c 0002
0000040 3239 527c 7c7c 3033 2f31 342f 3230 3038
0000060 7c31 322f 3331 2f39 3939 397c 447c 567c
0000100 447c 597c 4163 7469 7665 0000 0000 7c32
0000120 3030 3931 3030 323a 3130 3336 3330 0a00
0000137
thanks in advance
below are the hex values for the above one record
0000000 3030 3030 3330 3130 3033 3831 3434 7c00
0000020 0432 3138 3931 3231 3430 3032 307c 0002
0000040 3239 527c 7c7c 3033 2f31 342f 3230 3038
0000060 7c31 322f 3331 2f39 3939 397c 447c 567c
0000100 447c 597c 4163 7469 7665 0000 0000 7c32
0000120 3030 3931 3030 323a 3130 3336 3330 0a00
0000137
thanks in advance
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: