DML through multi table view

Database
Enthusiast

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

2 REPLIES
Junior Contributor

Re: DML through multi table view

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.

Enthusiast

Re: DML through multi table view

Thank you Dieter