Archives of the TeradataForum
Message Posted: Tue, 12 Feb 2008 @ 18:06:34 GMT
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:
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|