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 program, written in a language such as C or COBOL, which is located and called on a server or gateway process.
  • A file of executable commands written in the Dialogue Manager (DM) language of the server.
  • A transaction running under the control of a transaction-processing monitor such as CICS or IMS/TM.

Note: The ability to use the above methods is limited to what an underlying product (DBMS) supports and varies by platform. Any limitations will be noted in the documentation.

Stored procedures enable you to:

  • Embed procedural logic in your server applications. The logic may be modular, eliminating the need to recreate it for each application.
  • Update non-relational database management systems.

iWay Software