Rocket® Enterprise Developer (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
Recommended OpenESQL Directives for Open PL/I
Describes the SQL directives to use with Open PL/I for compatibility with OODBC, when migrating DB2 applications, and for Oracle date/time formatting.
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"