Archives of the TeradataForum
Message Posted: Wed, 04 Jan 2006 @ 17:04:46 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|