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

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

I am loading the data into files using...

Rate Topic

Display Mode

Topic Options

Author

Message

kiran_terydata

Posted 9/10/2009 2:20:30 AM

Forum Newbie

Group: Forum Members
Last Login: 10/20/2009 1:44:00 AM
Posts: 7, Visits: 10

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

KIRAN

Post #16790

Raja_kt

Posted 9/10/2009 6:33:08 AM

Forum Member

Group: Forum Members
Last Login: 10/22/2009 1:29:06 AM
Posts: 36, Visits: 182

Use mode record and format binary.

Teradata_cert_Oracle_cert

Post #16794

Steve Feinholz

Posted 9/10/2009 2:34:21 PM

Forum Member

Group: Forum Members
Last Login: 11/9/2009 3:27:04 PM
Posts: 38, Visits: 46

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.

Post #16802

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 4:55pm