Returns a random floating point value between 0 and 1. The argument is an expressions that returns the value of any built-in numeric data type.
Example:
Assume column HRAND has a value of 100. The following statement:
SELECT RAND(HRAND) FROM QSYS2.QSQPTABL
Returns a random floating-point number between 0 and 1, such as the approximate value .0121398.