Hi DBA's

How to call a stored procedure with in a stored procedure

for example

in a stored procedure we declare a variable and assign the value

select substr('EXAMPLE',1,4) into vlist from sysibm.sysdummy1;

how do assign the output of a stored procedure to other variable in a stored procedure

call (a,b,?)

how do we get the output to a variable in a stored procedure

any examples of calling stored procedures in stored procedures


Thanks

For example

call another_proc(a,b,vlist);

where another_proc was created by
CREATE PROCEDURE another_proc(IN x data-type1 , IN y data-type2 , OUT z data-type3) ...

thanks

it works