RecordDelim option

Specifies a string literal to use as the row or record delimiter.

The value must be a maximum 8-byte UTF-8 string.

Enter the end-of-record delimiter between single quotation marks. The default is the newline value:

On UNIX operating systems: '\n'
On Windows operating systems: '\r\n' or '\n\r'

The field is literally interpreted, so if you specify ‘\n’, the system looks for the string ‘\n’ instead of the newline indicator (\n). Define the omission of a record delimiter by using side-by side single quotation marks.