Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 14 Jan 2004 @ 16:39:03 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Fastload Problem
From:   Ramesh Pidaparthy

Hello all ,

i am trying to load the data which is exported using fexp which is in record mode.

i have somewhere around 74 columns in my table with Char, Decimal , Date , Timestamp,and integer data types.

In the define statement ,i am changing the values of the error reported columns to char .

As communicated, i have changed the Value of the field xxxx from Decimal (11,2) to char(11) and now i am getting 2679 which says The format or data which contains a bad character.

In fload log file the rows are getting loaded to error table instead of target table .I have checked in the Error table and i get 2679 Error .

At the end of log file the following messages are getting displayed.

     Total Records Read              =  10000
     Total Error Table 1             =  10000
     Total Error Table 2             =  0  ---- Table has been dropped
     Total Inserts Applied           =  0
     Total Duplicate Rows            =  0

     Start:   Wed Jan 14 09:20:46 2004
     End  :   Wed Jan 14 09:20:46 2004

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