Database Management Systems (DBMSs)

Lists supported and tested DBMSs along with the Enterprise Developer features that use them.

All RDBMS testing is done on both 32- and 64-bit platforms based on RDBMS client software availability.

With regard to support for each of these third-party RDBMS supported version, Micro Focus:

Provides support until the standard end-of-service (EOS) date provided by the RDBMS vendor
If your deployment requires support for a given RDBMS beyond the vendor's EOS dates, check with OpenText Support for Micro Focus Products for availability of Extended Support Plus options.
Encourages you to include third-party RDBMS consideration when planning an upgrade to your Enterprise Developer

With regard to resolving reported issues with Micro Focus software while using a third-party RDBMS, Micro Focus :

Attempts to resolve issues for supported DBMSs on tested or untested platforms
Investigates issues involving planned but not yet supported RDBMSs, and attempts to resolve non-architectural issues that also occur in the latest supported RDBMS version

This release of Enterprise Developer supports the following Database Management Systems:

COBSQL (Pro*COBOL)
HCO for DB2 LUW
HCO for PostgreSQL (HCOPG)
HCO for SQL Server (HCOSS)
OpenESQL
SQL Option for DB2

COBSQL (Pro*COBOL)

Note: COBSQL (Pro*COBOL) is supported for native COBOL only.

Before deploying a COBSQL application, be sure to install and configure all applicable third-party software.

Availability - Windows platforms

Operating System/Platform	32-bit	64-bit
x86-64 running Windows

Availability - UNIX platforms

Operating System/Platform	32-bit	64-bit
x86-64 running Red Hat Linux
x86-64 running SUSE Linux
IBM Power System running AIX
IBM System Z running Red Hat Linux
IBM System Z running SUSE Linux
Itanium running HP-UX
x86-64 running Solaris
SPARC running Solaris

XA Switch Module

The Oracle XA switch module is provided for COBSQL (Pro*COBOL), and is available on the same platforms as are indicated in the Availability section above. Oracle Instant Client fully supports all 1PC functionality with Pro*COBOL applications.

Restriction: The Oracle Instant Client does not support the 2PC functionality of the Oracle XA switch module. To use 2PC functionality with Pro*COBOL applications, you must install Oracle Client, not Instant Client.

Certification of RDBMS Precompilers for Native COBOL

Certification of RDBMS precompilers with Micro Focus products is the responsibility of the RDBMS vendor, rather than Micro Focus . Certification information can be found within the relevant Oracle documentation. If you have an https://support.oracle.com/epmos/faces/DocumentDisplay?id=43208.1 , document # 43208.1 provides details of all language compilers certified by Oracle for use with their precompilers.

Preprocessors

COBSQL supports the following database preprocessors:

Oracle Pro*COBOL versions 19c and 21c
Sybase Open Client Embedded SQL/COBOL version 11.1 and later
Informix Embedded SQL/COBOL version 7.3 and later

Compiling

On x86 and x86-64 platforms, when compiling with COBSQL for use with Oracle, do not use the COBSQL directive option NOMAKESYN, since this directive results in COMP host variables, and on Intel platforms these are incompatible with the native byte order expected by Oracle.

Supported/tested version

For this release, COBSQL was tested with Oracle Pro*COBOL versions 19c and 21c.

Planned support

Support for the following is planned for a future release:

Oracle 23c

HCO for DB2 LUW

Before developing or deploying an HCO for DB2 LUW application, be sure to install and configure all applicable third-party software.

Note: HCO for DB2 LUW is supported for native COBOL only.

Availability - Windows platforms

Operating System/Platform	COBOL 32-bit	COBOL 64-bit	PL/I 32-bit	PL/I 64-bit
x86-64 running Windows

Availability - UNIX platforms

Operating System/Platform	COBOL 32-bit	COBOL 64-bit	PL/I 32-bit	PL/I 64-bit
x86-64 running Red Hat Linux
x86-64 running SUSE Linux
IBM Power System running AIX
IBM Z System running Red Hat Linux
IBM Z System running SUSE Linux
Itanium running HP-UX
x86-64 running Solaris
SPARC running Solaris

XA Switch Module

The DB2 XA switch module is provided and is available on the same platforms as are indicated in the Availability section above.

Certification of RDBMS Precompilers for Native COBOL

Certification of RDBMS precompilers with Micro Focus products is the responsibility of the RDBMS vendor, rather than Micro Focus . You can find IBM document certification information for DB2/COBOL applications within the IBM Information Center for DB2, in the topic Support for database application development in COBOL .

Preprocessor

HCO for DB2 LUW supports the following database preprocessors:

IBM DB2 LUW version 11.1 and later
IBM DB2 Connect version 11.1 and later

Host Compatibility Option (HCO) - Windows platforms

Host Compatibility Option requires that you have one of the following software products installed and configured:

IBM DB2 Connect - Personal, Enterprise, Application Server or Unlimited Edition
IBM DB2 LUW - Workgroup or Enterprise Server Editions including Advanced versions
IBM DB2 LUW - Express or Express-C Edition
IBM Data Server Client (assumes installation of a remote DB2 LUW Server product)

Host Compatibility Option (HCO) - UNIX platforms

Host Compatibility Option requires that you have one of the following software products installed and configured:

IBM Database Connect
IBM DB2 LUW Personal Edition or DB2 Express-C
DB2 LUW Workgroup or Enterprise Edition

You must also install the DB2 Application Development Client (formerly called DB2 SDK) or you cannot compile any DB2 programs.

Supported/tested versions

For this release, HCO for DB2 LUW was tested with versions 11.1 and 11.5.

HCO for PostgreSQL (HCOPG)

Attention: This feature is in Early Adopter Program (EAP) release status. We intend to provide the finalized feature in a future release. Please contact OpenText Support for Micro Focus Products if you require further clarification.

Before developing or deploying an HCOPG application, be sure to install and configure all applicable third-party software.

Availability - UNIX platforms

Operating System/Platform	COBOL native 32-bit	COBOL native 64-bit
x86-64 running Red Hat Linux
x86-64 running SUSE Linux

Availability - Windows platforms

Operating System/Platform	COBOL native 32-bit	COBOL native 64-bit
x86-64 running Windows

Supported/tested versions

For this release, HCO for PostgreSQL was tested with:

Amazon Aurora PostgreSQL version 14.3 and later
Amazon RDS for PostgreSQL version 14.3 and later
PostgreSQL GDG community edition version 14 (early adopter program) and later

Note: No COBOL stored procedure support is available at this time.

HCO for SQL Server (HCOSS)

Before developing or deploying an HCOSS application, be sure to install and configure all applicable third-party software.

Availability - UNIX platforms

Operating System/Platform	COBOL native 32-bit	COBOL native 64-bit
x86-64 running Red Hat Linux
x86-64 running SUSE Linux

Availability - Windows platforms

Operating System/Platform	COBOL native 32-bit	COBOL native 64-bit	PL/I 32-bit	PL/I 64-bit
x86-64 running Windows

Availability - UNIX platforms

Operating System/Platform	COBOL native 32-bit	COBOL native 64-bit
x86-64 running Red Hat Linux
x86-64 running SUSE Linux

Database Migration

HCOSS Client Host node

SQL Server 2016 or later
Microsoft .NET Framework 4.7.2
Microsoft SQL Server Integration Services - available with the Microsoft SQL Server edition
Note: Microsoft SQL Server Express edition might not support SSIS. See your Microsoft documentation for details.
Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL)
Note: Microsoft recommends MSOLEDBSQL only, as all other versions are deprecated or are no longer maintained. However, if MSOLEDBSQL is not installed, SQL Server Native Client (SNAC) is used if available.
Microsoft OLE DB Provider for DB2 version 5.0 or later
Notes:
- Be sure to configure the OLE DB Provider to connect to the mainframe. See your Microsoft documentation for details.
- When using Microsoft OLE DB Provider for DB2 version 6.0, set the Extract Schema Cast STATEMENT column to VARCHAR during SysViews extract option.

SQL Server Target Host node

SQL Server 2016 or later

Mainframe DB2

IBM-supported z/OS DB2 versions only

Note: If you intend to develop applications on your local machine, but deploy applications to a SQL Server database on a remote machine, configure the remote machine using the requirements listed in the Deploying Native Applications > Deployment Machine section later in this topic.

Deploying Native Applications

Development Machine

Install SQL Server 2016 or later, along with its recommended Microsoft ODBC driver version.

Development SQL Server Machine

SQL Server 2016 or later.

Note: This can be the same machine as the development machine, but is not required to be.

Deployment Machine

Install Enterprise Server or Enterprise Test Server
Install SQL Server 2016 or later, along with its recommended Microsoft ODBC driver version.

If you want to bind your application from the deployment machine, install the following additional software:

Microsoft .NET 4 framework, or later
SQL Server 2016 or later System CLR Types
SQL Server 2016 or later Shared Management Objects

Deployment SQL Server Machine

SQL Server 2016 or later

Note: This can be the same machine as the deployment machine, but is not required to be.

Supported/tested versions

For this release, HCO for SQL Server was tested with SQL Server 2016, 2017, 2019, Azure DB, and Azure MI. Both SQL Server 2017 and 2019 were tested on Windows and Linux platforms.

OpenESQL

Before developing or deploying an OpenESQL application, be sure to install and configure all applicable third-party software.

Availability - Windows platforms

Operating System/Platform	COBOL native and JVM 32-bit	COBOL native and JVM 64-bit	PL/I 32-bit	PL/I 64-bit
x86-64 running Windows

COBOL Availability - UNIX platforms

Operating System/Platform	COBOL native and JVM 32-bit	COBOL native and JVM 64-bit
x86-64 running Red Hat Linux
x86-64 running SUSE Linux
x86-64 running Solaris
IBM Power System running AIX
IBM Z System running Red Hat Linux
IBM Z System running SUSE Linux
Itanium running HP-UX
SPARC running Solaris

PL/I Availability - UNIX platforms

Operating System/Platform	PL/I 32-bit	PL/I 64-bit
x86-64 running Red Hat Linux
x86-64 running SUSE Linux
IBM Power System running AIX
SPARC running Solaris

XA Switch Module - Windows platforms

The ODBC One-phase Commit, SQL Server, and PostgreSQL switch modules are provided and available on the same platforms as are indicated in the Availability section above.

XA Switch Module - UNIX platforms

The ODBC One-phase Commit switch module is provided and is available on the same platforms as are indicated in the COBOL Availability section above.

The SQL Server and PostgreSQL switch modules are available on the following platforms:

x86-64 running Red Hat Linux
x86-64 running SUSE Linux

Native COBOL and PL/I

OpenESQL supports access to relational databases using ODBC 3.0-compliant drivers
Refer to your driver vendor's documentation to determine whether your driver is suitable for use with OpenESQL

JVM COBOL

OpenESQL supports access to relational databases using JDBC 4.0-compliant JDBC drivers. The following table shows the tested DBMSs and their corresponding JDBC driver filenames:

Tested DBMS Versions	JDBC 4.0 Compliant Drivers
DB2 LUW 11.1 DB2 LUW 11.5	db2jcc4.jar (and db2jcc_license_cu.jar )
Oracle 19c Oracle 21c	ojdbc7.zip ¹
Microsoft SQL Server 2016 (Windows only) Microsoft SQL Server 2017 Microsoft SQL Server 2019	sqljdbc4.jar ²
EDB PostgreSQL 13.x and later	postgresql-42.0.0.jre7.jar
¹ Some Oracle JDBC drivers are distributed as .zip rather than .jar files. ² On Windows platforms, if you are not using Windows authentication, no additional resources are required. However, if you are using Kerberos authentication with a driver version of 4.0 or later, although integrated authentication is not required, you might need to follow additional configuration steps as described in the driver documentation. No additional resources are required for UNIX platforms.

To use JDBC DataSource Objects, you must also install and configure a JNDI server.

If you are using a Java application server, it includes a JNDI server you can use to configure DataSource objects. This process is described in the Java documentation for the application server.
If you are not using a Java application server, or if you require a standalone JNDI server to configure DataSource objects for initial evaluation and development, see the To install and configure Simple-JNDI topic for instructions on downloading, installing, and configuring the open source JNDI server Simple-JNDI for this purpose.

Supported/tested versions

For this release, OpenESQL was tested with:

Oracle 19c and 21c
DB2 LUW 11.1 and 11.5
SQL Server 2016, 2017, 2019, 2022, Azure DB, and Azure MI (Windows platforms)
SQL Server 2017, 2019, and 2022 (UNIX platforms)
Microsoft Azure SQL Database
Microsoft Azure SQL Managed Instance
PostgreSQL GDG community edition (early adopter program) and EDB PostgreSQL 13.x, 14.x, and 15.x
Amazon AWS Aurora and RDS for PostgreSQL 13.x, 14.x, and 15.x
MySQL 8.0 on all Windows platforms, and on the following UNIX platforms:
- x86-64 running Red Hat Linux
- x86-64 running SUSE Linux

Note: Micro Focus provides compatibility for PostgreSQL and MySQL but does not directly contribute to or support either open source project. Any issues relating to the functionality of either DBMS should be addressed through an open source support vendor.

SQL Option for DB2

Availability

Operating System/Platform	32-bit
x86-64 running Windows

XA Switch Module

XDB XA switch modules are provided and are available for the Windows x86-64 32-bit platform.