Hi,
I'm newbie in this informix stuff,
K, the question: how's the most basic for create an store procedure, I mean, how can I do that, an how it can returns a value,

thanks !!!!

Hi,

Here is a short example:

CREATE PROCEDURE my_square (i INT DEFAULT 0) RETURNING INT; {Notifies return of INT value}
DEFINE j INT;
LET j = i * i;
RETURN j; {Returns value of j to calling module}
END PROCEDURE;

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

Thanks a lot,
i'll check the link, your help was very usefull
thanks again...