Archives of the TeradataForum

Message Posted: Wed, 10 Nov 2004 @ 19:41:26 GMT

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

Hi,

I tried using the formattinmg the date data in the format 'MMMbDDbYYYYbHH:MIBT' in my fastload script's insert statement .

     insert into hin_hcc
        ( :hhx_hin_number ,

          :hhx_hcc_number ,

          :hhx_source_flag      ,
          cast(:hhx_statusdate as timestamp format 'MMMbDDbYYYYbHH:MIBT'),
              current_date,
              current_date,
              1,
              current_date,
              1
        );

But I am getting following error

"RDBMS error 3618: Expression not allowed in Fast Load Insert, column UPDT_DATE."

Could anyone please let me know if I can use the format clause in some other way in my fastload script.

Thanks and Regards,

Rachana'

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