3 Replies Latest reply on Apr 11, 2014 12:26 PM by shawkins

    custom DELETE query instead of the default one (in the transformation editor).

    teiiduser

      Hello,

       

      I am new to Teiid and Teiid Designer.

      I want to write a custom DELETE query instead of the default one (in the transformation editor). The user query may/may not have a where clause. Where can I find documentation for the syntax of TRANSLATE CRITERIA ?

       

      I have to write a custom delete query because with the default one when the user tries to execute

      delete from MyView where col='somevalue'

       

      I get this error:

      Error: TEIID30492 Remote org.teiid.api.exception.query.QueryValidatorException: TEIID30492 TEIID30061 Delete is not allowed on the view MyView.  A procedure may be needed to handle the Delete since: The non-simple query defining an updatable view does not have a valid key preserving delete target.

      SQLState:  50000

      ErrorCode: 30492

       

      Thanks in Advance!