Search code examples
randomnumberssybasesap-ase

how can i generate n unique random numbers in sybase

i need to generate n unique random numbers in sybase ase. The number n will be specified while executing the required stored proc.. ex : exec procedurename 12 should return 12 unique random numbers.

Is there a way to do this in sybase ase?

Thanks rinu

Solution

  • rand() and rand2() are the built in random number functions for SAP Sybase ASE.

    More information on these and other functions can be found here:

    Reference Manual:Building Blocks