Reading Pipe Delimited, Variable Length, EBCDIC file

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
Shaanpriya
Participant
Posts: 22
Joined: Thu Sep 11, 2008 11:47 pm
Location: Bangalore

Reading Pipe Delimited, Variable Length, EBCDIC file

Post by Shaanpriya »

Hello All,

We have a requirement for reading a Pipe Delimited, Variable Length, EBCDIC file. I am using a CFF stage for the same.
Things done
1) File layout imported
2) Record Type set as "Variable"
3) Character Set kept as "EBCDIC"

But where do we specify the Field delimiter in a CFF stage? I see an option called Record Delimiter. Tried changing that to a pipe but then am not able to "View Data". Getting the following error
" Missing record delimiter "|", saw EOF instead"

Has anyone imported such a file??

Thanks,
Priya.
Post Reply