HP 3000 Manuals HP 3000 Manuals
Installation
Before using the Micro Focus SQL database interface, you must install one
of the database systems listed in the section Supported SQL Systems. See
the documentation supplied with that system for installation details.
The database system provides various .dll files, so the SQL system must
be available at compilation and execution time.
If the SQL Communication Area is included in your program; that is, if
the following statement appears in your code:
exec sql include sqlca end-exec
then the file sqlca.cpy (on Windows and OS/2) or sqlca.cbl (on UNIX),
provided with this system, must also be present at compilation time.
For Microsoft SQL Server, Microsoft SQL Server Programmer's Toolkit for
COBOL must be available at compilation time in addition to Microsoft SQL
Server client software.
OS/2 For IBM Database Manager for OS/2, one of the
following .dll files supplied with this COBOL
system also must be available (that is the .dll
file must be in a directory on the LIBPATH):
* At compilation time
* _sqleec.dll (for IBM Extended Edition Database Manager)
* _sqle1c.dll (for IBM Extended Services Database Manager and
IBM DB2/2)
* At run time (.int and .gnt code only - available in the add-on
product Toolset for Windows and OS/2) or when animating
* _sqleen.dll or _sqleex.dll (for IBM Extended Edition
Database Manager)
* _sqle1n.dll or _sqle1x.dll (for IBM Extended Services
Database Manager and IBM DB2/2)
Windows The IBM DB2/2 Windows Requester is supported as a client
for both compilation and execution with a DB2/2 OS/2
Server. The Windows Requester provides various .dll
files, so the SQL system must be available at execution
time. You can compile as a Windows client, accessing
the DB2/2 OS/2 Server using the COBOL SQLRPS Remote
Database compilation described later in this chapter.
You can also compile directly on the DB2/2 OS/2 Server
or from an OS/2 client machine for execution support on
Windows.
Certain .dlw files supplied with this COBOL system must be available and
in a directory on the PATH:
* At compilation time:
* None (for a Windows client)
* _sqleel.dll (for a server using IBM Extended Edition
Database Manager)
* _sqle1l.dll (for a server using IBM Extended Services
Database Manager or IBM DB2/2)
* At run time (.int and .gnt code only - available in the add-on
product Toolset for Windows and OS/2) or when animating
* _sqle1n.dlw or _sqle1x.dlw
AIX The SQL system must be available at compilation and
execution time.
You must configure your login environment to set the COBOPT environment
variable to the name of the database parameter file:
COBOPT=/usr/lpp/db2_vv_rr_mmmm/lib/db2mkrts.args
export COBOPT
where the values of vv, rr and mmmm represent the version, release and
modification level of the DB2/6000 system installed on your machine.
Edit the file named in the COBOPT environment variable by removing the
-vdd option fromthe initial line of the file.
From the directory $COBDIR/src/sql enter:
sh mkrts
cp rts32 $COBDIR