The OpenESQL preprocessor provides two preprocessor options - ODBC for native code and
JDBC for JVM managed code.
- ODBC
- Use OpenESQL with the ODBC option to compile your native applications. This option:
- Is invoked using the SQL(DBMAN=ODBC) compiler directive
- Uses any ODBC drivers and data providers
- Connects to one or more ODBC data sources
- Compiles applications to communicate with the OpenESQL ODBC Runtime
- Enables maximum interoperability between different database systems
- Provides comprehensive support for pessimistic (locking) concurrency control
- Does not support disconnected or offline DataSets
- JDBC
- Use OpenESQL with the JDBC option to compile your JVM managed applications. This option:
- Is invoked using the SQL(DBMAN=JDBC) compiler directive
- Uses any of several JDBC drivers
- Can connect to one JDBC Data Source using either a JDBC Connection String or a JDBC DataSource Object.
- When connecting with a JDBC DataSource Object, enables you to connect to your Java data source for compilations with the SQL CHECK directive (this simulates OpenESQL DSNs with ODBC or ADO.NET)
- Compiles applications to communicate with the OpenESQL JVM Managed Runtime
- Enables maximum interoperability between different database systems
- Provides support for pessimistic and optimistic (locking) concurrency control
- Supports dynamic SQL using PREPARE, EXECUTE and EXECUTE IMMEDIATE statements and cursors that use prepared statements, but only with host variable lists in the EXECUTE and OPEN statements
- Does not support disconnected or offline DataSets
