CREATE PROCEDURE proc_test1_db2(
			   OUT p_out         INTEGER
			   ,IN p_num         INTEGER
--             ,IN p_name        VARCHAR(128)
)
   DYNAMIC RESULT SETS  1 
   LANGUAGE SQL
P1: BEGIN

   DECLARE v_cursor_statement VARCHAR( 1000 );
   DECLARE v_cursor_stmt STATEMENT;
   DECLARE v_out_cursor  CURSOR WITH RETURN FOR v_cursor_stmt;


   IF p_num IS NULL THEN
	  SIGNAL SQLSTATE 'ERROR' SET MESSAGE_TEXT='p_num is null';
   END IF;

END P1

./spcall -d db -u user -p pass esf2.proc_test1_db2  10 

cliRC = - 1 
  line  =  579 
  file  = spcall.c

  SQLSTATE          = ERROR
  Native Error Code = - 438 
[IBM][CLI Driver][DB2] SQL0438N  Application raised error with diagnostic text: "p_num is null".  SQLSTATE=ERROR

CREATE PROCEDURE proc_test31_db2(
			   OUT p_out INTEGER, IN p_num  INTEGER
)
P1: BEGIN

	SET p_out = p_num +  1 ;

END P1

./spcall -d db -u user -p pass esf2.proc_test31_db2  10 
Checking parameter # 0 
Checking parameter # 1 

P_OUT:

Checking parameter # 0 
P_OUT:  11 
Checking parameter # 1 

CREATE PROCEDURE proc_test3_db2(
			   INOUT p_num         INTEGER
)
P1: BEGIN

	SET p_num = p_num +  1 ;

END P1