Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 2.3 Update 2 for Eclipse > Programming > Data Access > Database Access > OpenESQL > OpenESQL DBMAN Use Case Scenarios

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)
Parent topic: OpenESQL
Previous Topic Next topic Print topic