Can I use AUTO_INCREMENT in a virtual table?

[snadji]

Hi,

Can I use AUTO_INCREMENT in a virtual table?

If yes what is the syntax? I tried different variations for the following but couldn't get it to work

CREATE VIEW MyVirtualView (

    FirstCol                string,

    AutoIncrementCol               integer NOT NULL AUTO_INCREMENT

    )

AS SELECT

    table1.FIRST_NAME               AS FIRST_NAME

FROM

    MyDatasource.Table1 table1

Thanks.

[rareddy]

Samier,

Teiid only supports sequences with Oracle, see https://docs.jboss.org/author/display/TEIID/Built-in+Translators

It is only supported in FOREIGN TABLE construct, the below format is correct.

AutoIncrementCol

integer NOT NULL AUTO_INCREMENT

Ramesh..