Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 12 Feb 2008 @ 18:06:34 GMT


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


Subj:   Re: Writing to tables thru views
 
From:   Michael Larkins

Gregg:

To my knowledge there is no "way around" this restriction nor will there ever be one. If you think about it, the restriction makes sense. When you are doing many of the operations you mentioned:

  block views built from joins, derived data, or column functions (e.g. SUM, COUNT, CSUM)  


Most of the time there is no corresponding column in a table. What is there to update and more importantly, where to update it?

The normal course of action if you are going to allow updates via a view, the view contains all columns or at least a subset of the columns, not a superset. BTW, if you are going to do this and your view is going to contain a WHERE - be sure to read about WITH CHECK OPTION in the view so that the upd/ins/del does not ignore the WHERE.


Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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