Application Building Guide

Micro Focus COBOL

This section contains the following topics:

• Using the Compiler

• DB2 API Applications

• DB2 Embedded SQL Applications

Using the Compiler

If you develop applications that contain embedded SQL and DB2 API calls, and you are using the Micro Focus COBOL compiler, keep the following points in mind:

• When you precompile your application using the command line processor command db2 prep, use the target mfcob option (the default).

• In order to use the built-in precompiler front-end, run-time interpreter or Animator debugger, add the DB2 Generic API entry points to the Micro Focus run-time module rts32 by executing the MKRTS command provided by Micro Focus, as follows:

  1. Log in as root.

  2. Execute MKRTS with the arguments supplied in the following directory:

        /opt/IBMdb2/V6.1/lib/db2mkrts.args
     

• You must include the DB2 COBOL COPY file directory in the Micro Focus COBOL environment variable COBCPY. The COBCPY environment variable specifies the location of COPY files. The DB2 COPY files for Micro Focus COBOL reside in sqllib/include/cobol_mf under the database instance directory.

  To include the directory, enter:

     export COBCPY=$COBCPY:$HOME/sqllib/include/cobol_mf
  

  Note:

  You might want to set COBCPY in the .profile file.

DB2 API Applications

The script file bldmfapi, in sqllib/samples/cobol_mf, contains the commands to build a DB2 API program. The parameter, $1, specifies the name of your source file.

#! /bin/ksh # bldmfapi script file. # Usage: bldmfapi <prog_name> # Set DB2PATH to where DB2 will be accessed. # The default is the standard instance path. DB2PATH=$HOME/sqllib # Set COBCPY to include the DB2 COPY files directory. export COBCPY=$DB2PATH/include/cobol_mf:$COBCPY # Compile the checkerr.cbl error checking utility. cob -cx checkerr.cbl # Compile the program. cob -cx $1.cbl # Link the program. cob -x $1.o checkerr.o -L$DB2PATH/lib -ldb2 -ldb2gmf

Compile and Link Options for bldmfapi
The script file contains the following compile options: cob The Micro Focus COBOL compiler. -cx Compile to object module.
The script file contains the following link options: cob Use the compiler as a front end for the linker. -x Specify an executable program. $1.o Include the program object file. checkerr.o Include the utility object file for error-checking. -L$DB2PATH/lib Specify the location of the DB2 static and shared libraries at link-time. For example: $HOME/sqllib/lib. -ldb2 Link with the DB2 library. -ldb2gmf Link with the DB2 exception-handler library for Micro Focus COBOL. Refer to your compiler documentation for additional compiler options.

To build the sample program client from the source file client.cbl , enter:

   bldmfapi client

The result is an executable file, client. You can run the executable file against the sample database by entering the executable name:

   client

Embedded SQL Applications

The script file bldmfcc, in sqllib/samples/cobol_mf, contains the commands to build an embedded SQL program.

The first parameter, $1, specifies the name of your source file. The second parameter, $2, specifies the name of the database to which you want to connect. The third parameter, $3, specifies the user ID for the database, and $4, specifies the password. Only the first parameter, the source file name, is required. Database name, user ID, and password are optional. If no database name is supplied, the program uses the default sample database.

#! /bin/ksh
# bldmfcc script file.
# Usage: bldmfcc <prog_name> [ <db_name> [ <userid> <password> ]]
 
# Set DB2PATH to where DB2 will be accessed. 
# The default is the standard instance path.
DB2PATH=$HOME/sqllib
 
# Connect to a database.
if (($# < 2))
then
   db2 connect to sample
elif (($# < 3))
then
   db2 connect to $2
else
   db2 connect to $2 user $3 using $4
fi
 
# Precompile the program.
db2 prep $1.sqb bindfile
 
# Bind the program to the database.
db2 bind $1.bnd
 
# Disconnect from the database.
db2 connect reset
 
# Set COBCPY to include the DB2 COPY files directory.
export COBCPY=$DB2PATH/include/cobol_mf:$COBCPY
 
# Compile the checkerr.cbl error-checking utility.
cob -cx checkerr.cbl
 
# Compile the program.
cob -cx $1.cbl
 
# Link the program.
cob -x $1.o checkerr.o -L$DB2PATH/lib -ldb2 -ldb2gmf

Compile and Link Options for bldmfcc
The script file contains the following compile options: cob The Micro Focus COBOL compiler. -cx Compile to object module.
The script file contains the following link options: cob Use the compiler as a front end for the linker. -x Specify an executable program. $1.o Include the program object file. checkerr.o Include the utility object file for error-checking. -L$DB2PATH/lib Specify the location of the DB2 static and shared libraries at link-time. For example: $HOME/sqllib/lib. -ldb2 Link with the DB2 library. -ldb2gmf Link with the DB2 exception-handler library for Micro Focus COBOL. Refer to your compiler documentation for additional compiler options.

To build the sample program updat from the source file updat.sqb , enter:

   bldmfcc updat

The result is an executable file, updat. You can run the executable file against the sample database by entering the executable name:

   updat

[ DB2 List of Books | Search the DB2 Books ]