Remove column headings from Fexport output

Tools

Remove column headings from Fexport output

Hi,

I am executing a Fexport in Unix. I use sel * from tablename. My export is working fine. However, i need to fastload this to TD again in different env.

I am getting the column names as well with the data in the file. Any option by which i can remove that ? I believe it would be done with some SET command, but i am not able to figure out whch one?

3 REPLIES
Supporter

Re: Remove column headings from Fexport output

can you share your fastexp script?

Which export format did you use?

Supporter

Re: Remove column headings from Fexport output

And by the way - did you recognise the 

MLSCRIPT option in the EXPORT command?

It can be quite nice.

Also TPT would allow you to move data between systems without landing this to files.

Enthusiast

Re: Remove column headings from Fexport output

Fast export doesn't export column headers.

Do visit the below link for more info....

http://forums.teradata.com/forum/tools/export-data-with-column-name-using-fast-export