An application typically executes a stored procedure though a front-end tool such as an API call to the server or any number of WebFOCUS mid-tear tools. The initial procedure is usually a 4GL Dialogue Manager procedure that, in turn, calls other 4GL Dialogue Manager procedures, compiled 3GL procedures, or a combination of both.

The following types of procedure calls are supported:

• A direct call to a compiled 3GL procedure using EDARPC.
• A 4GL Dialogue Manager procedure, which can call:
  • A compiled program, using the command CALLPGM or EXEC.
  • A proprietary RDBMS procedure, using SQL Passthru mode (where supported).
  • An IMS/TM transaction, using the CALLIMS or CALLIMSC procedure.
  • Another Dialogue Manager procedure, using the command EXEC.

The following figure shows calls to stored procedures from Dialogue Manager.