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 (
AutoIncrementCol integer NOT NULL AUTO_INCREMENT
table1.FIRST_NAME AS FIRST_NAME
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|