All Forums Database
spkother 18 posts Joined 07/13
17 Oct 2014
DML through multi table view

Hi,
    I was trying to insert record into one of the base table through multi table view,it is giving error saying "View may not be used for insert/update/delete".but same insert working fine on single table view.Why?can anyone give explanation for this.
Thanks,
Sravanthi
   

dnoeth 4628 posts Joined 11/04
18 Oct 2014

Hi Sravanthi,
Teradata (like most DBMSes) doesn't allow updates on multi-table views.
Only single-table SELECTs without JOIN, ORDER BY, aggregations or calculations can be updated.

Dieter

spkother 18 posts Joined 07/13
18 Oct 2014

Thank you Dieter

You must sign in to leave a comment.