Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 16 May 2005 @ 13:42:01 GMT


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


Subj:   Error 6707 During Fastload of Timestamp(0) Field
 
From:   John Henderson

All,

I'm attempting to load a file into a Teradata table on V2.5 that contains an outputted date and time field from another system. The format of the fields are DDMMMYY and HH.MM.SS (e.g. "12MAY05 03.04.15", etc.).

My define is written as:

     ", START_SUBM (CHAR(16))",

and my insert is written as

     ", :START_SUBM (FORMAT'DDMMMYY HH.MM.SS',TIMESTAMP(0))",

however I'm getting a 6707 error on this field during the FastLoad execution. Every input record is being written to error table 1 and referencing this field as the bad field. Does anyone have any suggestions as to what I should change to correct this issue, or is it even possible to load a timestamp in this format?

Alternatively, I can (and have successfully) break the fields into a date field and a separate time field, but I'm having issues combining them to update into a timestamp field after the load completes. I'd consider using this second method as a viable option if I can't get the first option to work. Ultimately, I want to be able to calculate the interval between a submission and completion timestamp when I'm finished. Any suggestions would be greatly appreciated!


Thanks,

John



     
  <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: 15 Jun 2023