FASTEXPORT output file column name

Tools & Utilities
Fan

FASTEXPORT output file column name

How can I define in the FASTEXPORT script the first row in the exported file to be the names of the exported columns ?
Tags (1)
1 REPLY
Teradata Employee

Re: FASTEXPORT output file column name

you must write 2 select clause in the .BEGIN EXPORT/.END EXPORT grou^p
the first clause will be a simple select with the name of the columns as litteral string
and the second select will be your selection for export.
.begin export...;
select cast( ('foo'|| ';' || 'bar'||';' || baz) as char(30) );
select cast( (foo || ';' bar || ';' baz ) as char(30) )
from MyFavoriteTable;
.end export;