Version 4.2.6 for Mainframes
 —  Database Management System Interfaces  —

NDB - Natural Stored Procedures and UDFs

NDB supports the writing and executing of Natural stored procedures and Natural user-defined functions (Natural UDFs).

Natural stored procedures are user-written programs that are invoked by the SQL statement CALL and executed by DB2 in the SPAS (Stored Procedure Address Space). SPAS is a separate address space reserved for stored procedures.

A function is an operation denoted by a function name followed by zero or more operands that are enclosed in parentheses. A function represents a relationship between a set of input values and a set of result values. If a function has been implemented by a user-written program, DB2 refers to it as a user-defined function (UDF).

This section covers the following topics:

Types of Natural UDF

PARAMETER STYLE

Writing a Natural Stored Procedure

Writing a Natural UDF

Example Stored Procedure

Example UDF

Security

Top of page