Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 12 Feb 2008 @ 16:22:17 GMT


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


Subj:   Writing to tables thru views
 
From:   william.gregg

Two items:

1) It is my understanding that restrictions on table updates thru views block views built from joins, derived data, or column functions (e.g. SUM, COUNT, CSUM) from performing the ins/upd/del action.

Has anyone found a way around this?


2) Adding the WITH CHECK OPTION enforces constraints thru the WHERE clause (otherwise the WHERE clause is ignored.)

I recall that the WITH CHECK OPTION clause was not working correctly. Is this true?

Will employment of the WITH CHECK OPTION produce faulty updates?


Thanks,

Bill Gregg

Teradata Team
Thomson Healthcare



     
  <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: 27 Dec 2016