Invoking programs through the Interactive System Productivity Facility

You can use ISPF to invoke programs that connect to DB2® through the call attachment facility (CAF).

About this task

The ISPF/CAF sample connection manager programs (DSN8SPM and DSN8SCM) take advantage of the ISPLINK SELECT services, letting each routine make its own connection to DB2 and establish its own thread and plan.

With the same modular structure as in the previous example, using CAF is likely to provide greater efficiency by reducing the number of CLISTs. This does not mean, however, that any DB2 function executes more quickly.

Disadvantages: Compared to the modular structure using DSN, the structure using CAF is likely to require a more complex program, which in turn might require assembler language subroutines. For more information, see Call attachment facility.
  • ISPF
    The Interactive System Productivity Facility (ISPF) helps you to construct and execute dialogs. DB2 includes a sample application that illustrates how to use ISPF through the call attachment facility (CAF).
  • Invoking a single SQL program through ISPF and DSN
    When you invoke a single SQL program through ISPF and DSN, you should first invoke ISPF, which displays the data and selection panels. When you select the program on the selection panel, ISPF calls a CLIST that runs the program.
  • Invoking multiple SQL programs through ISPF and DSN
    You can break a large application into several different functions. Each function communicates through a common pool of shared variables, which is controlled by ISPF.
Parent topic: Running an application on DB2 for z/OS