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.
COBSQL (Pro*COBOL)
Note: COBSQL (Pro*COBOL) is supported for native COBOL only.
- Availability
-
Feature/Platform
|
32-bit
|
64-bit
|
x86-64 running Windows
|
X
|
X
|
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 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:
- Sybase Open Client Embedded SQL/COBOL Version 11.1 or later
- Oracle Pro*COBOL Version 11.1 (11gR1) 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.
OpenESQL
- Availability
-
Feature/Platform
|
Native COBOL 32-bit
|
Native COBOL 64-bit
|
PL/I 32-bit
|
x86-64 running Windows
|
X
|
X
|
X
|
x86-64 running Red Hat Linux
|
X
|
X
|
X
|
x86-64 running SuSE Linux
|
X
|
X
|
X
|
IBM System p running AIX
|
X
|
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
|
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
Availability section above.
For Windows environments, the SQL Server XA switch module is also provided.
- 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. In order to utilize JDBC DataSource Objects, you must also install and configure a JNDI server.
HCO for SQL Server (HCOSS)
- Microsoft SQL Server
- SQL Server 2008 R2 or SQL Server 2012, Developer or Enterprise Editions, including Microsoft SQL Server Management Studio.
- Database Migration
-
- Microsoft .NET Framework 4.0
- Microsoft OLE DB Provider for DB2, available in the SQL Server 2008 R2 or 2012 Feature Pack
Note: Be sure to configure the OLE DB Provider to connect to the mainframe. See your Microsoft documentation for details.
- Mainframe DB2
Note:
- We support only the mainframe DB2 versions that are currently under IBM support.
- If you intend to develop applications on your local machine, but deploy applications to a SQL Server database on a remote machine, you can install SQL Server Native Client 10.x (or later) for ODBC connectivity on your local machine instead of installing SQL Server. For information on configuring a deployment machine, see the section
Deploying Native Applications below.
- Deploying Native Applications
-
- Development Machine
-
- Enterprise Developer
for Eclipse
- If SQL Server 2008 R2 or 2012 is not installed, you must have Microsoft SQL Server 2008 R2 or 2012 Native Client installed
- Development SQL Server Machine
- SQL Server 2008 R2 or 2012
Note: This can be the same machine as the development machine, but is not required to be
- Deployment Machine
-
- Enterprise Server or
Enterprise Test Server installed
- If SQL Server 2008 R2 or 2012 is not installed, you must have Microsoft SQL Server 2008 R2 or 2012 Native Client installed
If you want to bind your application from the deployment machine, install the following software in addition:
- Microsoft .NET 3.5 framework, or later
- SQL Server 2008 R2 or 2012 System CLR Types
- SQL Server 2008 R2 or 2012 Shared Management Objects
- Deployment SQL Server Machine
- SQL Server 2008 R2 or 2012
Note: This can be the same machine as the deployment machine, but is not required to be
HCO for DB2 LUW
- Availability
-
Feature/Platform
|
Native COBOL 32-bit
|
Native COBOL 64-bit
|
PL/I 32-bit
|
x86-64 running Windows
|
X
|
X
|
X
|
x86-64 running Red Hat Linux
|
X
|
X
|
X
|
x86-64 running SuSE Linux
|
X
|
X
|
X
|
IBM System p running AIX
|
X
|
X
|
X
|
IBM System z running SuSE Linux
|
X
|
X
|
|
Itanium running HP-UX
|
|
X
|
|
x86-64 running Solaris
|
|
|
|
SPARC running Solaris
|
X
|
|
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 9.5 or later
- IBM DB2 Connect Version 9.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.
SQL Option for DB2
Feature/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.