Re: Stored Procedure Question

ramajig@aol.com (Ramajig) wrote: :There seems to be no in creating a procedure. However I personally would :not like to do it. Because in an environment with n-users simultaneously :invoking the 4GL code will create 'n' different procedures all performing :a similar task but with multiple copies registered with the engine. Not a :very elegant method. You may want to create one stored procedure and make :all users use that single copy. :I stand corrected if anyone gives me a good logical reason in support of :this method. I agree that creating stored procedures as proposed isn't a good solution. He can't create one stored procedure though, as he states he wants to read different columns from different tables. I do believe however that exactly the same can be implemented in 4GL by simply preparing the statement. There was a discussion some time ago on this problem here at c.d.i. that you may want to look up. If you used ESQL/C this could all be programmed more elegantly, but possibly with some more effort (at least if you aren't allready proficient in ESQL/C). Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org