RE: How to execute procedure
"Prashant
Sh...." <PShirude@manh.com> wrote:
>
>CREATE PROCEDURE AUTO_APPROVE_SHIPMENT
> (vshpid LIKE SHIPMENT.SHIPMENT_ID,> OUT vPassFail INT
> )
>
>How to execute above procedure when there is one Input and one out
>parameter.
Please see the IBM Informix Guide to SQL: Tutorial. You will find it here,
if you don't already have it -
http://www-306.ibm.com/software/data/informix/pubs/library/list2.html#G
There is an entire chapter devoted to creating and using SPL routines.
You'll want to review the format for creating a procedure (function) that
returns a value, and there are several ways to execute a procedure or
function. You haven't provided enough information about how you will be
using the procedure to give you the syntax for execution.
--
June Hunt