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: 01/30/2023