AppLib RAND

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Parameters 4 Output 5 Example 6 Source Code

Syntax

   APPLIB.RAND ( minimum, maximum )

Purpose

Returns a random number. Return is an integer value.

Parameters

• minimum: minimum value of the generated random number. [INTEGER]
• maximum: maximum value of the generated random number. [INTEGER]

Output

• [INTEGER] Random number between minimum and maximum values.
  • Throws an exception if minimum is not less than maximum and if either input is null

Example

VALUES( APPLIB.RAND(99, 1023) )

Value returned will be between 99 and 1023 inclusive.

Source Code

http://p4web.eigenbase.org/open/dev/luciddb/src/com/lucidera/luciddb/applib/numeric/RandUdf.java