Archives of the TeradataForum
Message Posted: Sat, 17 Mar 2001 @ 17:00:57 GMT
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))
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|