Specifying UNIX EOF as Record Delimiter

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

Specifying UNIX EOF as Record Delimiter

Post by ag_ram »

Hi Folks

How can we specify UNIX EOF as record Delimiter while reading a Sequential file
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

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

"You can never have too many knives" -- Logan Nine Fingers
imbos123
Charter Member
Charter Member
Posts: 18
Joined: Mon Jul 24, 2006 1:43 pm

Post 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
Thanks
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post 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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply