Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 06 Jan 2007 @ 11:14:31 GMT

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

Subj:   Re: Creating tables 50% to 90% of columns as unique primary index
From:   frank.c.martinez

Thank you, a search using "UPDATE (Upsert form)" allowed me to find the reference and fully understand the answer. As one of my fellow dba's here said, I'd heard of the upsert, but never seen the syntax.

As far my comment being tongue and check, well, the phrase "hand-coded Atomic Upsert" just brought up some weird and interesting images. Sometimes when I'm reading the NCR manuals, some of the new phrases seem to be from another world. For example, when I was reading the documentation on the Atomic Upsert, I also noticed another link to a discussion about using a "Mutator SET Clause". With the holidays now officially over, I can only hope that evil reindeer-riding bad guy was dealt his just deserts our hero, Atomic.


  <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: 28 Jun 2020