Archives of the TeradataForum

Message Posted: Mon, 27 Sep 2005 @ 00:12:21 GMT

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

Please change your SQL as below and try to load

     INSERT INTO table_a (
       datefield1
      , otherfiled1
      , otherfield2
      , datefiled2
      , otherfield3
      , otherfield4
      , otherfield5
     )
     VALUES
      (
              :input_field1    (format 'YYYYMMDD')
       /*** on changing to (DATE, FORMAT 'YYYYMMDD') works fine ***/
              ,:input_field2
              ,NULLIF(:input_field3,'')
              ,:input_field4 (format 'YYYYMMDD')
       /*** on changing to (DATE, FORMAT 'YYYYMMDD') works fine ***/
              ,NULLIF(:input_field5,0)
              ,NULL(:input_field6,0)
              ,:input_field7
     ) ;

Thanks,

Prasanna.K

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