Introducing Stored Procedures

Topics:

A stored procedure is a program or procedure that resides on the execution path of a server. The procedure is called by a client application but can also be called or nested by another explicitly requested procedure. It is executed on the server on which it resides.

A stored procedure is one of the following:

  • A compiled 3GL program, written in a language such as C or COBOL, which is located and called on a server or gateway process.
  • A file of 4GL commands (known as a FOCEXEC) written in a combination of Dialogue Manager (DM) syntax and/or other commands, such as SET, TABLE FILE, SQL and DBMS passthru that run on the server.

This manual describes the use of compiled 3GL programs. Although 4GL FOCEXEC syntax was covered in a limited way in previous versions of this manual, that syntax is fully covered in other documents, such as the Developing Reporting Applications, Creating Reports With WebFOCUS Language, and Server Administration manuals and has, therefore, been removed from this manual.


iWay Software