Archives of the TeradataForum
Message Posted: Thu, 16 Jan 2003 @ 15:03:13 GMT
| Subj: || || Re: Column titles and titledashes should not appear in the export file. |
| From: || || Craig Windland |
Here is another way using fast export. You can imbed this in a shell script and cat the created file.
Personally, I don't know of a method that places only data to standard out. Teradata needs to work on this!
Personally, I find this superior to the bteq method.
.export outfile FILE.DAT format text;
CAST(COL1 AS CHAR(99) )
,CAST(COL2 AS CHAR(99) )
,CAST(COL,etc AS char(99))
where WHERE PREDICATE CONDITION