Was this helpful?
OpenSQL Features
The availability of some OpenSQL features depend on the version of OpenSQL supported by the host DBMS to which your application connects. To determine which version of OpenSQL the host DBMS supports, select the row containing the OPEN/SQL_LEVEL capability from the iidbcapabilities system catalog.
The following OpenSQL features are only available when the OPEN/SQL_LEVEL value in the iidbcapabilities system catalog is 00605 or higher:
Create schema statement
Grant and revoke statements
Create table statement: column constraints and defaults
Schema.table syntax
Delimited identifiers
The escape clause in the like predicate
Database procedures
For Enterprise Access, newer OpenSQL features may be available even though the Open/SQL_LEVEL value is not at 00605 or higher. For the current availability of OpenSQL features, see the Enterprise Access documentation.
Last modified date: 11/28/2023