seq

Returns a sequence number. The number can be initialized to any value, and the increment can be defined for each call. The syntax is:

	seq(increment [, init])

If init is given then the sequence number is initialized to that value, which will be the value returned. It is then incremented by increment. If init is not specified then the current value will be retained. The initial value will be zero if init has not been specified.

Examples of typical use:

     SELECT  NAME, seq(1)
     FROM    SYSTABLES

The results are:

NAME seq(1) SYSTABLES 0 SYSCOLUMNS 1 SYSINDEX 2 SYSUSERS 3 SYSPERMS 4 SYSTRIG 5 SYSMETAINDEX 6

     SELECT  seq(0, 100)
     FROM    SYSDUMMY;

     SELECT  NAME, seq(1)
     FROM    SYSTABLES

The results are:

seq(0, 100) 100 NAME seq(1) SYSTABLES 100 SYSCOLUMNS 101 SYSINDEX 102 SYSUSERS 103 SYSPERMS 104 SYSTRIG 105 SYSMETAINDEX 106