To provide maximum compatibility with OpenESQL for ODBC applications, simply change -SQL ODBC to -SQL OCI.
This example shows how to use directives for optimum performance of Open PL/I applications with OCI.
-SQL OCI -OPTSQL "BEHAVIOR=OPTIMIZED"
This example shows the additional SQL directives to use when migrating mainframe DB2 applications.
DATE=USA // or EUR, ISO or JIS as appropriate DETECTDATE CHECKDUPCURSOR CHECKSINGLETON
This example shows the directives to use to provide Oracle date/time formatting.
-SQL OCI -OPTSQL "DATE=EXTERNAL"