Reading file through schema 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
Suruchi
Participant
Posts: 16
Joined: Tue Dec 13, 2011 3:21 am

Reading file through schema file

Post by Suruchi »

Hi,
I reading a text file through schema file.My end of line character is \n.When I am specifying record_delim='\n' in schema file , records are getting rejected while reading.When i run cat -e -v <<filename>> I can see \n$ as the last character.What option should i specify as record_delim?
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I'm not sure of which UNIX "cat" you are using, some act a bit differently. But "\n$" is odd, since the -e option would change the "\n" to "$" (I think). Can you do a "od -x" on the file and show one line?
Post Reply