Archives of the TeradataForum

Message Posted: Wed, 04 Jan 2006 @ 17:04:46 GMT

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

Jay:

You cannot use the self-defining INSERT statement unless the incoming data record matches the table column list exactly. Yours does not match, your input record is all character data and your table has two numeric columns. Change your INSERT to use the VALUES portion to substitute and convert from varchar to the table data type. Once you have fixed your INSERT it will work.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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