Archives of the TeradataForum

Message Posted: Fri, 30 Nov 2007 @ 14:48:29 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I believe the question about which OS you are using was about the client; i.e., which OS FastLoad is running on, not Teradata.

Assuming that you are running FastLoad on *nix or Linux, there is no way to change the default record delimiter. The notion that newline ('\n' or x'0A') is the end of a record is built into the OS at a very low level. For instance, getline() depends on this assumption.

So we're back to the old question: what problem are you trying to solve? If the incoming records have differing numbers of fields, you could run them through a preprocessing routine (perl, awk, DataStage, whatever) to make sure that every record has the proper number of fields before handing it to FastLoad.

	<Prev	Next>		<<First	<Prev	Next>	Last>>