Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Nov 2005 @ 12:36:31 GMT


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


Subj:   Re: Fastexport, multiload, nulls and blanks
 
From:   Simon Bloomer

Many thanks for the series of answers on this. I couldn't find anything in the manuals that discuss this, so I guess that's what the forum is for!

As part of the same issue, how do people normally deal with upserts in mload where there are nullable columns which are part of a multicolumn UPI? (I don't want to debate the logic of nullable UPI columns :). The way I see it is that a null does not equal a null - therefore the upsert will attempt to insert a new row, andwill fail because of a dupkey error.

I have a solution to this but was wondering how others would deal with it.


Regards

Simon



     
  <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