DB2 Version 10.1 for Linux, UNIX, and Windows

Building UNIX Micro Focus COBOL applications

You are provided with build scripts for compiling and linking Micro Focus COBOL embedded SQL and DB2® administrative API programs. You can find the scripts in the sqllib/samples/cobol_mf directory. The directory also contains sample programs that you can build with these files. You can find the commands to build a DB2 application program in the bldapp build file.

About this task

The first parameter, $1, specifies the name of your source file. This is the only required parameter for programs that do not contain embedded SQL. Building embedded SQL programs requires a connection to the database so three optional parameters are also provided: 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.

For an embedded SQL program, bldapp passes the parameters to the precompile and bind script, embprep. If no database name is supplied, the default sample database is used. The user ID and password parameters are only needed if the instance where the program is built is different from the instance where the database is located.

To build the non-embedded SQL sample program, client, from the source file client.cbl, enter:

   bldapp client

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

   client

Procedure

There are three ways to build the embedded SQL application, updat, from the source file updat.sqb:
1. If connecting to the sample database on the same instance, enter:
```
   bldapp updat
```
2. If connecting to another database on the same instance, also enter the database name:
```
   bldapp updat database
```
3. If connecting to a database on another instance, also enter the user ID and password of the database instance:
```
   bldapp updat database userid password
```
  The result is an executable file, updat.
There are three ways to run this embedded SQL application:
1. If accessing the sample database on the same instance, enter the executable name:
```
   updat
```
2. If accessing another database on the same instance, enter the executable name and the database name:
```
   updat database
```
3. If accessing a database on another instance, enter the executable name, database name, and user ID and password of the database instance:
```
   updat database userid password
```