1 Reply Latest reply on Jun 30, 2014 3:24 PM by Steven Hawkins

    Teiid and ODATA - cannot set primary key as Nullable

    teiiduser Newbie

      Hello All,

       

      I have a view in which I declare a column to be a primary key, but I have set it as NULLABLE because I am generating it in the backend. I do not want the user to pass it.

       

      id integer PRIMARY KEY  /*Observe - no NOT NULL*/

       

       

      I generate the value myself here and pass it in the Insert trigger:

      DECLARE integer VARIABLES.id = /**generate value/

       

      This works in JDBC.

       

      But, this is not working with ODATA. how do I make this work in ODATA? Having a primary key , but nullable and let it know that the value will be handled in the backend?

       

      Thank you!