Writing Database Procedures › Methods for Invoking Procedures

Methods for Invoking Procedures

A database procedure is called as an extension of the database engine. A procedure can be called directly by IDMSDBMS. This is referred to as the Direct invocation method. Alternatively, a procedure can be invoked indirectly by using one of two techniques referred to as DBSTUB1 and DBSTUB2. These are described later in this section.

The methods that can be used to invoke a given procedure depend on several factors:

• Language of the procedure
• Reentrancy or LE-compliance
• Calling conventions that it uses
• Whether it issues IDMS DML requests

The following table identifies the methods that can be used for invoking procedures with differing characteristics. Where multiple invocation methods are listed as valid, the recommended method is highlighted.