Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 31 Aug 2010 @ 14:44:22 GMT


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


Subj:   Re: Does multiload work with inequlity conditions
 
From:   Maccha Narayana Rao Naidu

Anshuman,

The Error 3538 indicates that an UPDATE statement in a MultiLoad Task that does not fully specify a primary index value, specify the values of all the partitioning columns,or modifies the primary index or partitioning columns. So u need to use the Primary Index value for the Update stmt to work. Meaning u need to use "=". Because u are updating the record based on the PI value matching.

Hope this resolve the issue


Thanks

Machha.N



     
  <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: 15 Jun 2023