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
Customer Care for availability of Extended Support Plus options.
- Encourages you to include third-party RDBMS consideration when planning an upgrade to your
Micro Focus product
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)
Back to Top
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
|
X
|
X
|
- Availability
- UNIX platforms
-
| Operating System/Platform
|
32-bit
|
64-bit
|
| x86-64 running Red Hat Linux
|
X
|
X
|
| x86-64 running SUSE Linux
|
X
|
X
|
| IBM Power System running AIX
|
X
|
X
|
| IBM System Z running Red Hat Linux
|
X
|
X
|
| IBM System Z running SUSE Linux
|
X
|
X
|
| Itanium running HP-UX
|
X
|
X
|
| x86-64 running Solaris
|
X
|
X
|
| SPARC running Solaris
|
X
|
X
|
- 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
Oracle MetaLink account , 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 version 19c database preprocessor
- Sybase Open Client Embedded SQL/COBOL version 11.1 or later
- Informix Embedded SQL/COBOL version 7.3 or 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 version 19c.
HCO for DB2 LUW
Back to Top
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
|
X
|
X
|
X
|
X
|
- 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
|
X
|
X
|
X
|
X
|
| x86-64 running SUSE Linux
|
X
|
X
|
X
|
X
|
| IBM Power System running AIX
|
X
|
X
|
X
|
|
| IBM Z System running Red Hat Linux
|
X
|
X
|
|
|
| IBM Z System running SUSE Linux
|
X
|
X
|
|
|
| Itanium running HP-UX
|
|
X
|
|
|
| x86-64 running Solaris
|
|
|
|
|
| SPARC running Solaris
|
X
|
X
|
X
|
X
|
| PowerLinux LE running Red Hat Linux
|
|
X
|
|
|
| PowerLinux LE running SUSE Linux
|
|
X
|
|
|
- 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 10.5 or later
- IBM DB2 Connect version 10.5 or 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 10.5, 11.1, and 11.5.
HCO for SQL Server (HCOSS)
Back to Top
Note: HCO for SQL Server is available on Windows platforms only.
Before
developing or deploying an HCOSS application, be sure to install and configure all applicable third-party software.
- Availability
-
| Operating System/Platform
|
COBOL native and .NET 32-bit
|
COBOL native and .NET 64-bit
|
PL/I 32-bit
|
PL/I 64-bit
|
| x86-64 running Windows
|
X
|
X
|
X
|
X
|
- Database Migration
-
- HCOSS Client Host node
-
- SQL Server 2014 or later
[5]
- Microsoft .NET Framework 4.7.2
- 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 2014 or later
[5]
- Azure SQL Database or Azure SQL Managed Instance
- 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 2014 or later, along with its recommended Microsoft ODBC driver version.
- Development SQL Server Machine
- SQL Server 2014 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 2014 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 2014 or later System CLR Types
- SQL Server 2014 or later Shared Management Objects
- Deployment SQL Server Machine
- SQL Server 2014 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 2014, 2016, 2017, and 2019.
- Planned support
- Support for SQL Server 2017 and 2019 on Linux is planned for a future release.
OpenESQL
Back to Top
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
|
X
|
X
|
X
|
X
|
-
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
|
X
|
X
|
| x86-64 running SUSE Linux
|
X
|
X
|
| x86-64 running Solaris
|
X
|
X
|
| IBM Power System running AIX
|
X
|
X
|
| IBM Z System running Red Hat Linux
|
X
|
X
|
| IBM Z System running SUSE Linux
|
X
|
X
|
| Itanium running HP-UX
|
X
|
X
|
| SPARC running Solaris
|
X
|
X
|
| PowerLinux LE running SUSE Linux
|
|
X
|
| PowerLinux LE running Red Hat Linux
|
|
X
|
- PL/I Availability
- UNIX platforms
-
| Operating System/Platform
|
PL/I 32-bit
|
PL/I 64-bit
|
| x86-64 running Red Hat Linux
|
X
|
X
|
| x86-64 running SUSE Linux
|
X
|
X
|
| IBM Power System running AIX
|
X
|
|
| SPARC running Solaris
|
X
|
X
|
- 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 PostgreSQL switch module is 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 10.5
DB2 LUW 11.1
DB2 LUW 11.5
|
db2jcc4.jar (and
db2jcc_license_cu.jar )
|
|
Oracle 19c
|
ojdbc7.zip
1
|
|
Microsoft SQL Server 2014
(Windows only)
Microsoft SQL Server 2016
(Windows only)
Microsoft SQL Server 2017
Microsoft SQL Server 2019
|
sqljdbc4.jar
2
|
| EDB PostgreSQL 10.5 and 11.x
|
postgresql-42.0.0.jre7.jar
|
|
1 Some Oracle JDBC drivers are distributed as
.zip rather than
.jar files.
2 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
-
DB2 LUW 10.5, 11.1, and 11.5
-
SQL Server 2014, 2016, 2017, and 2019
(Windows platforms)
- SQL Server 2017 and 2019
(UNIX platforms)
- Microsoft Azure SQL Database
- Microsoft Azure SQL Managed Instance
-
GDG and EDB PostgreSQL 10.x, 11.x, and 12.x
- Amazon Aurora for PostgreSQL 2.x and 3.x
-
MySQL 5.7 (5.3 ODBC drivers only)
on all Windows platforms, and
on the following UNIX platforms:
- x86-64 running Red Hat Linux
- x86-64 running SUSE Linux
- PowerLinux LE
on remote Linux server using DB2 LUW 10.5 only
-
PowerLinux LE using DB2 LUW 10.5 only
(UNIX)
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.
- Planned support
- Support for the following is planned for a future release:
- EDB and GDG PostreSQL 13.x
- MySQL 8.0
SQL Option for DB2
Back to Top
- Availability
-
| Operating System/Platform
|
32-bit
|
| x86-64 running Windows
|
X
|
- XA Switch Module
- XDB XA switch modules are provided and are available for the Windows x86-64 32-bit platform.