Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

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


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


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!



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