 |
 |
Archives of the TeradataForum
Message Posted: Tue, 12 Feb 2008 @ 18:06:34 GMT
| 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
| |
