DB2 Create Procedure
The DB2 Create Procedure Tool allows users to create stored procedures for a database. The following example is output for DB2.
CREATE PROCEDURE TESTUSER.test_procedure
(IN param1 CHAR(25), INOUT param2 DECIMAL, OUT param3 DATE)
LANGUAGE SQL
MODIFIES SQL DATA
--READS SQL DATA
--CONTAINS SQL
--insert procedure body here
