This tutorial explains how to build a local batch COBOL DB2® application.
The COBOL source code file LDB2SAMP.cbl and copybook EMPLOYEE.CPY,
available in the Related References, below, are written for use with
this scenario. Before starting this example, you need to create a
local z/OS® project and add
these samples to your project.
To build a local batch COBOL DB2 application,
follow these steps:
- Open the Local COBOL Build Options property
page.
- In the SYSLIB field, type the path
to the DB2 sqlca.cbl file
followed by any other paths that include copybooks that the program
uses, separated by semicolons. The default path is C:\Program
Files\IBM\SQLLIB\include\cobol_a. Even if the copybook
resides in the same project as the COBOL source, the project path
must be included in the SYSLIB. For example, C:\Program
Files\IBM\SQLLIB\include\cobol_a;C:\myProject\source.
- Click the Source contains embedded SQL check
box.
- If a database connection is configured for the project,
click the Browse button, select the database
connection name from the list of Database Connections, and click OK.
- If a database connection is not configured for the project,
follow these steps:
- Click New Connection, select
the Create New Connection radio button, and
click Next.
- On the Connection Parameters page, select the database
manager to be used for development from the Select a database
manager list. For example, DB2 UDB V8.2.
- From the JDBC driver drop-down
list, select the JDBC driver to use. For example, the
default for DB2 UDB is IBM
DB2 Universal.
- In the Database field, type the
name of the database the program uses. The LDB2SAMP.cbl
program uses the Sample database that is shipped with DB2 UDB.
- In the Host field, type localhost.
- If the Port Number or the class
location is different from the defaults change them to suit your installation.
- In the User information fields,
type a user ID and password.
- Click the Test Connection button
to ensure the connection parameters are correct and then click Finish.
- On the Local Link Options property
page set Link Options to /de db2api.lib and
then click Finish or OK.
- In the z/OS Projects
view, select LDB2SAMP.cbl and then select Nominate
as entry point from the pop-up menu.
- Right-click the project name and select Rebuild.
The executable that is generated to the BuildOutput folder
can now be executed or debugged as a compiled application.