Re: SQL Return Value from Stored Procedure

Matt

I've not done this but can make a guess.

Have you looked at the SET statement? Seems a good candidate for doing this. Something like

set :hostintvar = storedproc(parm1, parm2,...)

Otherwise, use an INOUT parameter instead of a return value.

The docs say a return statement must return an INTEGER - that'd be 10i 0 - I don't think we should hardly EVER use B data types in RPG anymore. Certainly not with SQL stuff.

HTH
Vern

On 6/5/2013 3:03 PM, Matt Olson wrote:

Folks,

When you execute a SQL stored procedure from RPG, how do you get the return value of the stored procedure, and what is the data type (INTEGER? If so then is it defined a "9B 0")?

We are executing it by doing a CALL storedprocname

Thanks,

Matt