DSXchange

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?

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?