hi,

I'm new in INFORMIX and i want to know wether Informix procedures are able to return a result set (a list of employees for example).

if yes how it works ?

I looked for this in some documentation but i didn't find any information about it.

please if you can confirm me .

thanks in advance,

Hi,
first , in procedure body, you must use
CREATE PROCEDURE func_name (input_params)
RETURNING output_params
...
FOREACH
( put return value to output_params )
RETURN output_params WITH RESUME
...
END PROCEDURE

then, Call the procedure use
PREPARE ps FROM "EXECUTE PROCEDURE func_name (input_params)"
DECLARE cur CURSOR FOR ps
so, you can get the values of procedure's result set.