DB2 Version 4.1: Stored Procedure

Stored Procedures

A stored procedure is a user-written program stored at the DB2 server and invoked by client applications through the SQL CALL statement. DB2 V4.1 stored procedure implementation supports the ISO/ANSI SQL CALL standard as proposed for SQL3.

Local or remote applications can access a stored procedure, which can be written in COBOL, OO COBOL, C, C++, PL/I, FORTRAN, Assembler, or REXX.

Each parameter in the CALL statement is assigned to the corresponding parameter of the procedure. Once the procedure has finished its work, the value of each parameter in the procedure is assigned to the corresponding parameter (variable structure) in the calling program.