What SQL version does iAS support ?
AWith the exception of container-managed persistence, iAS does not generate or use SQL; in that sense it could be said that iAS does not support any SQL version. However, iAS can act as a proxy for database access for all applications that it supports; this means that it has to be able to support all the operations required by the JDBC 2.0 specification. Any application that excepts to find JDBC compliance at that level will be supported by iAS. JDBC 2.0 is largely based on the SQL-2 language, so it is reasonable to say that iAS supports SQL-2.However, iAS will generally support vendor-specific enhancements to SQL-2 if they return results that are standard data types supported by JDBC 2.0.
