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!