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. :?

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.