I am loading the data into files using fastexport but...

Tools
Enthusiast

I am loading the data into files using fastexport but...

Hi

I am loading the data into files using fastexport but the data is in binary format eventhough i am using text format,

please send me a sample script to load the data into tables in a text format.

Thanks

kiran
2 REPLIES
Enthusiast

Re: I am loading the data into files using fastexport but...

Use mode record and format binary.
Teradata Employee

Re: I am loading the data into files using fastexport but...

If the layout of the table consists of non-character fields (i.e. integer, decimal) then the data
will be returned to FastExport in binary format.

If you want the data in text format, then you would need to CAST your columns to CHAR or
VARCHAR.

-- SteveF