Previous Topic Next topic Print topic


Database Access

The following new features have been added as part of database access support:

COBSQL
This release provides:
  • Selection and configuration of the Oracle Pro*COBOL preprocessor for compiling COBSQL applications in a project's properties on the SQL Preprocessor page and in the build configuration settings.
  • Support for COBOL directives SOURCEFORMAT(TERMINAL) and SOURCEFORMAT(VARIABLE) for Pro*COBOL applications.
DB2 ECM
This release provides:
  • Support for the MFHCO environment variable across all platforms by default. See the HCO DB2 compiler directive option topic for details.
  • A new DB2 compiler directive option, OPTPER (NOOPTPER), that enhances performance for CHARSET EBCDIC processing. See the OPTPER DB2 compiler directive option topic for details.
  • A new DB2 directive option, BINDDIR, which specifies an alternative directory in which to write the DBRM file created during compilation. You can set BINDDIR from the command line or specify it in your project's properties. See the BINDDIR DB2 compiler directive option topic, and the Binding topic for details.
OpenESQL
This version of Visual COBOL supports the following new OpenESQL features:
Date/Time Processing
This release provides streamlined datetime processing for ODBC and JDBC.
OpenESQL Assistant
OpenESQL Assistant Options are now set via the Eclipse IDE from Window > Preferences > Micro Focus > Database > OpenESQL Assistant (applies to Windows environments only).
Performance
This release includes a new SQL compiler directive option, OPTPER (NOOPTPER), that enhances performance for CHARSET EBCDIC processing. See the OPTPER SQL compiler directive option topic for details.
PostgreSQL
In this release, PostgreSQL 9.4 has been tested with OpenESQL using the following PostgreSQL software:
Server software
PostgreSQL EnterpriseDB version 9.4.4
Client software
  • psqlODBC driver version 09.03.04.00
  • JDBC41 PostgreSQL driver version 9.4-1201
In this release, PostgreSQL 9.4 has been tested with OpenESQL and OpenESQL Assistant on the following platforms:
  • Windows 32-bit
  • Windows 64-bit
  • X86-64 running Red Hat Linux, 32- and 64-bit
  • X86-64 running SuSE Linux, 32- and 64-bit
In this release, PostgreSQL 9.4 has been tested with OpenESQL on the following platforms:
  • X86-64 running Red Hat Linux, 32- and 64-bit
  • X86-64 running SuSE Linux, 32- and 64-bit
Note: Micro Focus provides compatibility for PostgreSQL but does not directly contribute to or support the PostgreSQL open source project. Any issues relating to PostgreSQL functionality should be addressed through an open source support vendor.
SQL Server
This release provides support for the SQL Server OUTPUT clause.
XA Switch Modules
Restriction: This feature applies only when the Enterprise Server feature is enabled.

In this release, the XA interface has been redesigned to provide:

  • Consistent look and feel for SQL Server, DB2, and Oracle user personalization
  • Consistent look and feel for both RM dynamic and static registration (SQL Server, DB2, Oracle, generic one-phase commit)
  • Additional support for two instances of the same switch module using Web Services applications via the new XAID compiler directive
Previous Topic Next topic Print topic