Thanks a lot for your reply.
I read the documentation and the two requests. They are helpful.
My question is I cannot find the entry point in Designer to create Update Procedures.
In the session of "Using the INPUTS qualifier in Update Procedure", you mentioned:
In all the "update", "insert" and "delete" tabs in the Designer, you can define a Teiid procedure that will is reflective of the actual insert, update and delete you want to do.
But I could not find the tabs in Teiid Designer UI. I am tried Eclipse 3.5 and 3.6 with Teiid Designer 7.0/7.1 respectively.
I can create procedure from the view model UI. But I do not know it is Virtual Procedure or Update Procedure.
Would you please kindly give some guide on this silly question?
Thank you, Robert!
Now it works :-)