Was this helpful?
Ingres OpenSQL Unsupported Features
In the following table, the “X” designates Ingres OpenSQL features not supported by the gateways. If these unsupported features are used, the gateway or the DBMS execution generates an error, and the error is returned to the front-end.
Ingres Unsupported Feature
Microsoft SQL
Oracle
Create view with select command joined by the union operator
X
X
Update table commands using data from table in subquery (sqlcode -360)
X
X
DROP INDEX indexname; table_name.index_name must be used in DROP INDEX command
X
 
Last modified date: 08/22/2022