Input row delineation

Input rows are separated by any of the common end-of-line conventions: <CR><LF>, <LF><CR>, <CR>, or <LF>. In UNIX environments, <LF> is commonly known as NewLine. The last row or last line does not need an end-of-line character.

The <CR><CR> or <LF><LF> pairs are not valid end-of-line sequences. Instead each pair encloses an empty row that contains no values. The system considers such an empty row valid only if you specified the fillRecord option, and you specified that every column in the target table is able to be set to null.