-
1. Re: an error when insert into vdb
shawkins Oct 19, 2017 7:48 AM (in response to uuliver)There is an updatable property for all source tables. It will depend upon the metadata import or ddl that was used to define the table if it defaults to updatable. What source are you dealing with and how was the table metadata defined?
-
2. Re: an error when insert into vdb
uuliver Oct 19, 2017 8:32 AM (in response to shawkins)I SET UPDATABLE =TRUE IT ALSO ERROR
Error: TEIID30492 Remote org.teiid.api.exception.query.QueryValidatorException: TEIID30492 TEIID30061 Insert is not allowed on the view TEST.BOOK. A procedure may be needed to handle the Insert since: The query defining an updatable view has no valid target for INSERTs.
-
3. Re: an error when insert into vdb
shawkins Oct 19, 2017 9:04 AM (in response to uuliver)See Updatable Views · Teiid Documentation
It depends on your view definition and the insert columns as to whether Teiid can determine an allowable insert inherently. If it cannot, then you get the error you are seeing with the workaround of using a for each row insert trigger to handle the insert behavior with procedure logic.
-
4. Re: an error when insert into vdb
uuliver Oct 19, 2017 9:53 AM (in response to shawkins)Thank you very much for your help