1

I have a flat file which I am trying to load through fastload. The flat file has date in the format dd/mm/yyyy. When I am trying to load it through fastload the records are going in the Error tables. However, when I change the format of date in the flat file as yyyy-mm-dd 00:00:00 its loading for that column its loading fine.

07/27/2011 00:00:00 -- not working
2011-12-15 00:00:00--working


errlimit 1000000;
tenacity 4;        
sessions 1;
sleep 6;
dateform Ansidate,

SET RECORD VARTEXT "|*|" ; I am taking dateform Ansidate in the script

David Ansermot
  • 6,052
  • 8
  • 47
  • 82
user3901666
  • 399
  • 11
  • 29

1 Answers1

1

ANSIDATE always expects yyyy-mm-dd format.

You need to add a Teradata style typecast in your INSERT using a FORMAT matching your input string:

:PROMISE_DTTM(timestamp(0), format 'mm/dd/yyyyBhh:mi:ss')
dnoeth
  • 59,503
  • 4
  • 39
  • 56
  • I tried to do that but again it was redirecting it to error table. below is my Fload script, can you please tell me where should i add: insert into GEEDW_D_PLP_S.CDR_FETCH_PARTSDWH_ORDER_LN_D ( ORDER_LINE_D_KEY, ORDER_HEADER_D_KEY, PROMISE_DTTM, ) VALUES ( :ORDER_LINE_D_KEY, :ORDER_HEADER_D_KEY, :PROMISE_DTTM(timestamp(0), format 'yyyy-mm-ddBhh:mi:ss'), – user3901666 Oct 07 '14 at 11:58
  • Ok.. Let me try..will get back to you.Thank you for response :) – user3901666 Oct 08 '14 at 17:38