How about rand()? ( Was Re: Math in Informix SQL

In article <4k1kfm$h05@cssun.mathcs.emory.edu>, Jonathan Leffler <johnl@informix.com> wrote: >Well, in 6.00 and later versions, at any rate, the mathematical operators >are built-in: >ABS, MOD, POW, ROOT, ROUND, SQRT, TRUNC, >EXP, LOGN, LOG10, HEX, >COS, SIN, TAN, ASIN, ACOS, ATAN, ATAN2 > >Try them in your version; they were present before they were documented. > >Yours, >Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> > How about a random function? To the best of my knowledge there's not one in 4GL. I've used C function calls in the compiled version but this doesn't help when you've only got RDS... I guess you'd have to write your own pseudo random number generator using math functions there. -- ===================================================================== = Neal Howard neal@metronet.com '91 XLH-1200 DoD #686 AMA NRA = = "Fuzzy Wuzzy was a bear, Fuzzy Wuzzy had no hair. If Fuzzy Wuzzy = = had no hair, then Fuzzy Wuzzy wasn't Fuzzy, wuz he ?!!!" = = http://www.flash.net/~neal <-------My home page. = =====================================================================