Syntax for OPTIONS for Column

[teiiduser]

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!

[shawkins]

Columns also accept the options clause.  "col1 varchar(20) not null options ..." The columns will default to updatable if the table is marked as updatable and they are selectable by default.  See DDL Metadata - Teiid 8.8 (draft) - Project Documentation Editor