All Forums Tools
24 Feb 2012
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?

 

ulrich 816 posts Joined 09/09
24 Feb 2012

can you share your fastexp script?

Which export format did you use?

 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

ulrich 816 posts Joined 09/09
24 Feb 2012

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.

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Stefans 38 posts Joined 02/12
29 Feb 2012

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

Stalin

You must sign in to leave a comment.