Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 14 Jan 2004 @ 17:07:20 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Fastload Problem
From:   Mirjam Berger


your problem might not be with the decimal values. Fastexport & Fastload both support Decimal.

However, Timestamp is not supported by fastload. We generally export timestamps as char data TIMESTAMP(6) => CHAR(26), and also define them as CHAR(26) when loading them.

(I don't think time is supported either. You can get a complete list from your fastload documentation under the define command)

Also, if you exported your Decimals as Decimals I don't think that just changing the load the CHAR will do much for you.

When problems like this occur with your data, check the following:

1. Is our fastexport set to be in record mode as well. Load and export need to agree on the mode. If one is record, the other needs to be record too. If one is indicator, the other needs to be indicator too.

2. Are you exporting fields that are of any 'VARxxx' data-type, or that are nullable? If so you need to adjust your modes to be indicator.

3. Do you have timestamp or time fields that you did not define as char upon load (not even sure if you need to cast them to char in the export) (same goes for any other of the datatypes not supported...say Interval...)

These are the problems I have mostly expirienced in that context.

Hope this helps & you gets this solved soon :)


Mirjam Berger

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020