Archives of the TeradataForum

Message Posted: Sat, 17 Mar 2001 @ 17:00:57 GMT

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

Hi Wayne:

I might suggest an alternative to an OUTMOD.

If your SELECT uses a literal, Teradata can build the output file for you with delimiters.

SELECT CAST(column1 as VARCHAR(25))||':'||CAST(column2 as VARCHAR(25))
...
FROM table-name;

Of course, I have used fictious columns and the same length, but I am sure you get the idea. If you are using delimiters, it is probably wise to TRIM the fixed length CHAR columns before the CAST function.

Then, I used the colon (:) as a delimiter. You could use an character or characters you wanted.

As for FastExport, you will probably want to use the FORMAT portion of the .EXPORT to set the file type up as "UNFORMAT".

Hope this saves you some time and frustration.

Regards,

Mike

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