Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019