Search code examples
sqlhanahana-sql-script

HANA: How can I set the seed on the RAND() function?

I am trying to fix the pseudo random numbers generated by the RAND() function in HANA sqlscript.
I'm pretty sure it must be possible but the documentation is not very explicit.

Thank you.

Solution

  • There's no seeding option available for RAND() and neither for RAND_SECURE().