Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Visual Studio 2017 > 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 Maximize performance and talk to an SQL Server data store via a .NET data provider SQL(DBMAN=ADO, TARGETDB=MSSQLSERVER, BEHAVIOR=OPTIMIZED)
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 Mimic Oracle Pro*COBOL functionality for SQL cursors, and talk to an Oracle data store via .NET data provider SQL(DBMAN=ADO, TARGETDB=ORACLE, BEHAVIOR=ANSI)
Parent topic: OpenESQL
Previous Topic Next topic Print topic