1 Reply Latest reply on Apr 28, 2014 11:57 AM by Steven Hawkins

    Syntax for OPTIONS for Column

    teiiduser Newbie

      Hello,

       

      I am defining a dynamic VDB using the XML DDL format. I want to create a view and need to replicate the properties that appear in the Teiid Designer.

       

      CREATE VIEW MyView

      (col1 varchar(20) NOT NULL,

      col2 varchar(20) NOT NULL,

      col3  integer

      CONSTRAINT MyView_PK PRIMARY KEY (col1,col2)) OPTIONS (UPDATABLE 'YES')

      )

      AS

      Select

      (col1,col2,col3 from MySource) where (................)

       

      I also want to define individual columns col1 and col2 as Selectable and Updatable. What is the syntax to do so?

       

      Thanks in Advance!