Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Help required with Mload!
From:   Michael Larkins


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.


Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019