Additional Software Requirements for Micro Focus Enterprise Developer UNIX Components

Java EE 7, including support for EJB 3.2 and Java Connector Architecture 1.7, is supported for the deployment of EJBs.

The following Java application servers are supported using the following JDKs:

The availability of COBOL and CICS resource adapters for these Application Servers differs between UNIX platforms. The following table indicates where support is available for each platform:

Before you can use Enterprise Developer to develop and deploy SQL applications that use COBSQL, HCO for DB2 LUW, or OpenESQL, ensure any third-party software prerequisites are installed and the environment is set properly.

Availability

Feature/Platform	32-bit	64-bit
x86-64 running Red Hat Linux	X	X
x86-64 running SUSE Linux	X	X
IBM System p 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.

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 (http://metalink.oracle.com), 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 12.2 and 18c database preprocessors
• 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.

Executing

On HP-UX, to execute an application precompiled using Pro*COBOL (or COBSQL) after you have created a callable shared object of Oracle DBMS routines, you need set an environment variable, LD_PRELOAD, to point to the Oracle client callable shared object, for example:

LD_PRELOAD=$ORACLE_HOME/libdir/libclntsh.so       
export LD_PRELOAD

where libdir is:

• lib32 for 32-bit environments
• lib for 64-bit environments.

A script is available that creates an executable run-time system or a callable shared object containing Oracle support (applies to UNIX environments only). You can find the script in the Micro Focus Knowledge Base article titled Building and executing Pro*COBOL applications on UNIX.

Testing

For this version, COBSQL was tested with Oracle 12.2 and 18c.

Availability

Feature/Platform	Native COBOL 32-bit	Native 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 System p running AIX	X	X	X
IBM System z running Red Hat Linux	X	X
IBM System z 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)

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 will not be able to compile any DB2 programs.

Testing

For this version, HCO for DB2 LUW was tested with versions 10.5 and 11.1.

Availability

Feature/Platform	32-bit	64-bit
x86-64 running Red Hat Linux	X	X
x86-64 running SUSE Linux	X	X
IBM System p running AIX	X	X

OpenESQL

The MBDT toolset consists of OpenESQL applications, and are native code using ODBC. Please see the Database Access - OpenESQL section for further details.

Testing

For this release, MBDT was tested with DB2 LUW 10.5 and Oracle 12.2.

COBOL Availability

Feature/Platform	Native and JVM Managed COBOL 32-bit	Native and JVM Managed COBOL 64-bit
x86-64 running Red Hat Linux	X	X
x86-64 running SUSE Linux	X	X
x86-64 running Solaris	X	X
IBM System p 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
SPARC running Solaris	X	X
PowerLinux LE running SUSE Linux		X
PowerLinux LE running Red Hat Linux		X

PLI Availability

Feature/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 System p running AIX	X
SPARC running Solaris	X	X

XA Switch Module

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 Managed 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	db2jcc4.jar (and db2jcc_license_cu.jar)
Oracle 12.2	ojdbc7.zip*
Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017	sqljdbc4.jar
EDB PostgreSQL 10.5	postgresql-42.0.0.jre7.jar
*Some Oracle JDBC drivers are distributed as .zip rather than .jar files.

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 in this documentation set for instructions on downloading, installing, and configuring the open source JNDI server Simple-JNDI for this purpose.

Testing

For this version, OpenESQL was tested with:

• Oracle 12.2 and 18c
• DB2 LUW 10.5 and 11.1
• SQL Server 2012, 2014, 2016, and 2017
• PowerLinux LE using DB2 LUW 10.5 only
• EDB PostgreSQL 10.5 and MySQL 5.7 (5.3 ODBC drivers only) on the following 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.

Planned

Support for the following is planned for future release:

• SQL Server 2017
• Amazon Aurora PostgreSQL-Compatible Edition

Both running on the following platforms:

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