If the following conditions are true, then you must use hexadecimal digits to identify the delimiter:
- The character set of the access parameters is different from the character set of the datafile
- Some characters in the delimiter string cannot be translated into the character set of the datafile
The hexadecimal digits are converted into bytes, and there is no character set translation performed on the hexadecimal string.
So if u think it's the newline then guess u'll have to use the hex equivalent of \n (for the newline char!) or try CHARACTERSET US7ASCII?
But do post what worked !!