[Paulo Larini]

I'm very new in informix, and I want to know if I can have output parameters in a stored procedure like:

CREATE PROCEDURE TEST (A INT , B INT OUT)

thanks,

[vpshriyan]

Hi,

One can have both inbound and outbound parameters for a Stored Procedure.

Example:
create procedure test (a int) returning int;

You may look at the link below, which points to an official documentation on informix spl in pdf format. The title of the e-book is Informix Guide to SQL and the 8th chapter deals with creating and Using Stored Procedures.

http://www-3.ibm.com/software/data/i.../4366-pdf.html

Regards,
Shriyan