Stored Procedure _ Case STMT

[Uma]

Hi ..

I am writing a simple stored procedure like this ..

CREATE PROCEDURE DB2ADMIN.Proc1 (P1 INT,out P2 CHAR(20) )
RESULT SETS 1
LANGUAGE SQL
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
-- Declare cursor
declare V_ID_VALUE INT;
declare V_ARG CHAR(6) default 'PERM ';
-- declare cur1 cursor with return for select procname from
syscat.procedures

declare cur1 cursor with return for
select procname,
(case
when
procname='XP_LLIST' THEN 'XP_LIST'
ELSE
xpi_GetNextID(V_ARG, V_ID_VALUE)
end),
'xp'
from syscat.procedures ;
OPEN CUR1;

END P1

can I use the another stored procedure output ( xpi_GetNextID(V_ARG,
V_ID_VALUE) ) in the case statement ??
Thanks
Uma