Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

SQL Reference

Functions

Syntax

Example

 

SQL Reference

Joins

Nested Queries

Set Operations

ON CURSOR | INSTANCE

WITH Options

Commands

Functions

 

$RANDOM

Returns a pseudo-random number. The term "pseudo-random" is used as randomization is done using the Posix rand and srand functions. While these routines do provide satisfactory randomization for most applications, the numbers generated are not entirely random.

If seed is specified, it is used to start the random number generator. Note that only a single $random stream can be used in the process. If there are multiple $random functions in a select, only the first seed is used. Seed must be a literal. The return value is INTEGER length 4.

 

Syntax

$RANDOM[(seed)]

(seed)
Optional. Seed must be a literal.

 

Example

$RANDOM(9)

68
6151
...

Top