RE: Random number access on the i5

["Leibowitz, Larry" <Larry.Leibowitz@xxxxxxxxxxxxxxx>]

Works like a charm: (now how about 6 winning lotto numbers?)
INT
124

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
Sent: Friday, February 01, 2008 2:23 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Random number access on the i5

I don't know what qualifies as "certified", but have you considered
DB2's
RAND() SQL built-in?

Try it in interactive SQL, i.e.:

SELECT INT(RAND() * 1000) FROM SYSIBM/SYSDUMMY1

Search for built-in's description here:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmst
scal
e.htm#scarand

It's been around for a while (at least V5R2, maybe earlier).

HTH, Elvis