Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 12 Oct 2006 @ 12:22:42 GMT

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

Subj:   Re: Duplicate row error
From:   srinivasa rao batchu

I think your tables are getting created as SET tables. As SET table won't allow duplicate rows you are getting the Duplicate row error.

When you insert using Select statement it generally inserts all qualified rows (in your case no rows are qualified) and leaves all non- qualified rows. It won't give any error except giving the number of rows processed.

Thanks & regards

Srinivas Batchu

  <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