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 | 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) |