Archives of the TeradataForum

Message Posted: Thu, 13 Jul 2006 @ 21:05:43 GMT

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

Thank you for the response, David!

Unfortunately, 'mm/dd/yyyy' is not working.

My data are -

     SALE_DATE,PILOT
     07/01/2006,Y
     7/10/2006,Y

I am only able to load one record in -

     07/01/2006

Here is the run log -

     ***************************
     0014 insert into test values
          (:sale_date   (date, format 'mm/dd/yyyy')
          );

     **** 12:03:17 Number of recs/msg: 4284
     **** 12:03:17 Starting to send to RDBMS with record 2
     **** 12:03:17 Sending row 3
     **** 12:03:17 Finished sending rows to the RDBMS


          -------------------------------------------------------------------
          -                                                                 -
          -          End Loading Phase                                      -
          -                                                                 -
          -------------------------------------------------------------------

     0015 end loading;

     **** 12:03:18 END LOADING COMPLETE

          Total Records Read              =  3
           - skipped by RECORD command    =  1
           - sent to the RDBMS            =  2
          Total Error Table 1             =  1
          Total Error Table 2             =  0  ---- Table has been dropped
          Total Inserts Applied           =  1
          Total Duplicate Rows            =  0

          Start:   Thu Jul 13 12:03:18 2006
          End  :   Thu Jul 13 12:03:18 2006


     0016 logoff;

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