In this new tutorial of the TEIID series I'll show how to update the original table from the VDB view.
Usually when operating with TEIID designer the "orange" view model proposes just to read/select from the source table.
To be able to Update/Insert/Delete from the original table we must enable the "Support Update" checkbox as shown in the figure below.
In the video I'll show the whole procedure.
Mind that if you have "Auto Increment" columns you have also to go to the "Table Editor" tab in the "Transformation Editor" and ser the "Auto increment" option to true.