Previous Topic Next topic Print topic


Recommended OpenESQL Directives for Open PL/I

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"
Previous Topic Next topic Print topic