# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# 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`