OpenESQL provides a run-time system that uses Oracle's native OCI API. You can use the OCI API to run Open PL/I applications.
The benefits of this run-time system are:
- Better performance and reliability compared to Oracle's ODBC drivers
- Support for
BLOB,
CLOB,
BLOB_LOCATOR and
CLOB_LOCATOR host variables
- A date and timestamp formatting option that conforms to Oracle session settings for
NLS_DATE_FORMAT,
NLS_TIMESTAMP_FORMAT and
NLS_TIMESTAMP_TZ_FORMAT
- More comprehensive compile time checking with the SQL CHECK directive
- Switch module support for Oracle OCI, as well as for JES-initiated transactions connecting to Oracle data sources using OCI.