Parameters

DB2 is supporting input and output parameters. Furthermore parameters which are input AND output parameter are possible. The parameters must be specified in the create statement with the keywords IN, OUT or INOUT.

The parameters are optional, that means you can create procedures without any input or output paramters. At maximum 32.767 parameters can be specified in a stored procedure.

Default values are supported since DB2 9.5 in SQL PL procedures.

Example:

create procedure myproc (in var01 integer default null, out var02 integer, inout var03 varchar(20))
language sql
begin
  <procedure body>
end!


call myproc (100, ?, 'value03')