Re: Stored Procedure

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