Previous Topic Next topic Print topic


OpenESQL DBMAN Use Case Scenarios

The following OpenESQL use case scenarios show the appropriate SQL compiler directive options to set for each to ensure its ultimate success:

Type of Program Scenario SQL Compiler Directive Options
COBOL ANSI compliant, and talk to an SQL Server data store via an ODBC driver SQL(DBMAN=ODBC, TARGETDB=MSSQLSERVER, BEHAVIOR=ANSI)
COBOL or PL/I Maximize performance, not worry about mainframe compatibility, and talk to an Oracle data store via an ODBC driver SQL(DBMAN=ODBC, TARGETDB=ORACLE, BEHAVIOR=OPTIMIZED)
COBOL Maximize performance and talk to an SQL Server data store via a JDBC driver SQL(DBMAN=JDBC, TARGETDB=MSSQLSERVER, BEHAVIOR=OPTIMIZED)
Previous Topic Next topic Print topic