The CREATE PROCEDURE statement defines a procedure at the current server.
The following types of procedures can be defined:
The procedure program or service program is written in a programming language such as C, COBOL, or Java(TM). The external executable is referenced by a procedure defined at the current server along with various attributes of the procedure. See CREATE PROCEDURE (External).
The procedure is written exclusively in SQL. The procedure body is defined at the current server along with various attributes of the procedure. See CREATE PROCEDURE (SQL).
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.