Archives of the TeradataForum

Message Posted: Fri, 07 Mar 2003 @ 16:17:12 GMT

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

Hi MAB:

Loading a delimited file is one of the newer capabilities of Fastload. To accomplish this do the following:

1. DEFINE statement - all fields are VARCHAR with the longest possible length of characters in each (between delimiters)

2. use the SET RECORD command to define record as VARTEXT followed by your delimiter in quotes

That should pretty much take care of it for you. If you need an example, the manual has one and additional verbage on using this technique. Please be aware that Fastload will not run as fast using delimited files as it does with raw data because it must look at each character position to determine if it is a data character or a delimiter.

Good luck, Mike

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