RAND

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.