Programming for a DB2 environment

In general, the coding for a COBOL program will be the same if you want the program to access a DB2® database. However, to retrieve, update, insert, and delete DB2 data and use other DB2 services, you must use SQL statements.

About this task

To communicate with DB2, do these steps:

Code any SQL statements that you need, delimiting them with EXEC SQL and END-EXEC statements.
Start DB2 if it is not already started.
Compile with the SQL compiler option.
Compile with the NODYNAM compiler option if the application was compiled using the DB2 stand-alone precompiler.
Note: The NODYNAM compiler option is required for programs that contain EXEC CICS® or EXEC SQL statements.

If EXEC SQL statements are used in COBOL libraries that are loaded by a COBOL dynamic call, then one or more EXEC SQL statements must be in the main program. (Called DB2 APIs cannot be loaded using a COBOL dynamic call.)

related concepts
DB2 coprocessor