Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Fastexport to a "C" outmod utility to add a delimiter
From:   Michael Larkins

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.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023