Before you can use this product to deploy SQL applications developed for native COBOL with COBSQL, DB2 ECM or OpenESQL, ensure any third-party software prerequisites are installed and the environment is set properly.
- Availability
-
| Feature/Platform
|
DB2 ECM
(32-bit)
|
Host Compatibility Option
(32-bit)
|
COBSQL
(32-bit)
|
OpenESQL
(32-bit)
|
DB2 ECM
(64-bit)
|
COBSQL
(64-bit)
|
OpenESQL
(64-bit)
|
| IBM System p running AIX
|
X
|
X
|
X
|
X
|
X
|
X
|
X
|
| Itanium running HP-UX
|
X
|
X
|
X
|
X
|
X
|
X
|
X
|
| x86-64 running Red Hat Linux
|
X
|
X
|
X
|
X
|
X
|
X
|
X
|
| Itanium running Red Hat Linux
|
|
|
|
|
|
|
|
| IBM System z running Red Hat Linux
|
X
|
X
|
|
X
|
X
|
X
|
X
|
| SPARC running Solaris
|
X
|
X
|
X
|
X
|
|
X
|
X
|
| x86-64 running SuSE Linux
|
X
|
X
|
X
|
X
|
X
|
X
|
X
|
| IBM System z running SuSE Linux
|
X
|
X
|
|
X
|
X
|
X
|
X
|
Note:
- The Host Compatibility Option is available under 32-bit working mode only.
- On UNIX platforms, under a 64-bit working mode, OpenESQL is supported only for connection to Oracle through the Oracle Call Interface (OCI).
- Certification of RDBMS Precompilers
- 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 RDBMS documentation:
- Oracle
- 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.
- HCO for
DB2 LUW
- IBM document certification information for DB2/COBOL applications within the Information Center for DB2, in the topic
Support for database application development in COBOL.
- COBSQL
- COBSQL supports the following database preprocessors:
- Sybase Open Client Embedded SQL/COBOL Version 11.1 or later
- Oracle Pro*COBOL Version 10gR1 or later
- Informix Embedded SQL/COBOL Version 7.3 or later
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.
On HP-UX, in order 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.sl
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. You can find the script in the Micro Focus Knowledge Base article titled
Building and executing Pro*COBOL applications on UNIX.
- DB2 ECM
- DB2 ECM supports the following database preprocessors:
- IBM DB2 LUW Version 9.1 or later
- IBM DB2 Connect Version 9.1 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
If you are using DB2 LUW version 9.1 or later, you must also install the DB2 Application Development Client (formerly called DB2 SDK) or you will not be able to compile any DB2 programs.
- OpenESQL
-
- OpenESQL supports the following database preprocessors:
- Access to relational databases using ODBC 3.0-compliant drivers
- Connectivity to Oracle's OCI interface
- Refer to your driver vendor's documentation to determine whether your driver is suitable for use with OpenESQL
