Re: Stored Procedure

On Fri, 23 Dec 1994, Cathy Kipp wrote: } Kalyanaraman.L writes: } -> } ->Is there any way to use Stored procedure and triggers under informix-4GL. } } Yes. 4gl doesn't understand them itself, since the sql parser for 4gl was } written for earlier engines, so you need to send the request to your engine } (5 or 5.01 and up) which does understand them. if you prepare it and execute } it the processing takes place on the engine side. For example: } } prepare ex_stmt from "execute procedure my_stored_procedure (?)" } } execute ex_stmt using my_variable } } Regards, } } - Cathy } } -------------------------------------------------------------------------------- } Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (303) 491-1294 } Colorado State University Veterinary Teaching Hospital Fax: (303) 491-1205 } Thanks for your mail. In fact I tried the statement under 4GL it works fine as long as you don't return the value from the procedure. Can you pls help me how to return a procedure value into 4GL program. Thanks & regards Kalyanaraman.L