Page 1 of 1
Specifying UNIX EOF as Record Delimiter
Posted: Fri Mar 30, 2007 7:12 am
by ag_ram
Hi Folks
How can we specify UNIX EOF as record Delimiter while reading a Sequential file
Posted: Fri Mar 30, 2007 7:24 am
by chulett
Are you
sure you have a file with an
EOF as the
record delimiter? That doesn't make a whole lot of sense.
![Confused :?](./images/smilies/icon_confused.gif)
Posted: Fri Mar 30, 2007 8:48 am
by imbos123
Are you reading a DOS file with EOF in it in UNIX environment.
You can use below method to remove EOF character from the file.
Use it in Before Job routine in Job Properties as ExecSH method
tr -d '\032' < sourcefilename > intermediate_sourcefilename
use intermediate_sourcefilename in sequential file stage
Posted: Fri Mar 30, 2007 10:30 am
by DSguru2B
Do you mean UNIX New Line?
If yes, then you can set it in the format tab under Record Level property Record Delimiter.