Re: random number in a stored procedure

I doubt this would work as there is no way of returning anything from a system call short of having an external program inserting it into the database. Would be still slower. billy@west.co.za ("Billy Wheeler") wrote: :On 6 Dec 97 at 8:28, Ed Schaefer wrote: : :> Anybody out there written a stored procedure to return a random :> number. Any help is appreciated! : :Blunt, slow and ugly (just like me! :-) -- : :SYSTEM("exit `echo $RANDOM`") -- (Needs ksh) : :I think. I'm not really sure how you return things to SPs. Guaranteed :to be slow due to the system call, I'm afraid. : :HTH. 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