Archives of the TeradataForum

Message Posted: Fri, 25 Sep 2009 @ 16:17:01 GMT

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

You have a typo in your script, I am guessing that your field2 and field3 cannot take char data.

Hope that helps.

--Shridhar

     INSERT INTO MYTABLE
     (FIELD1,FIELD2,FIELD3)
     VALUES
     (
     TRIM(:FIELD1))
     ,(TRIM(:FIELD1))  -- should be field2
     ,(TRIM(:FIELD1))  -- should be field3
     )
     ;

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