Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 22 Dec 2007 @ 12:32:25 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Finding the set/multiset property of a table in the data dictionary
From:   Dieter Noeth

Dieter Capek wrote:

  Perhaps tvm.checkopt was a valid multiset table indicator in 2000 (when the mentioned post was written). A week ago I did check this and found multiset tables having both Y and N values on a TD Rel 5.0 system. My impression is that due to the lot of functionality added tvm.checkopt is not a valid indicator for the multiset property any longer.  

Tvm.checkopt just indicates if there will be duplicate row checks. A MULTISET table with a UNIQUE index simply doesn't require those checks.

If you add a unique index to a multiset table, checkopt will change to 'N' and if you drop the USI or alter the UPI to NUPI, it will be change back to 'Y'.

Btw, Merry Xmas :-)


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023