1

I am trying to generate a random character string of length 8 in Netezza, any suggestions?

sumanth
  • 11
  • 2

1 Answers1

1

If you're happy with a hex string, you could do:

select to_hex(round(random() * 2^32 - 1)::BIGINT) AS randchars;

You could also write a user-defined function if you want a very specific type of string. For this, you would need SSH access on the Netezza appliance and some basic knowledge of C++. It may be simpler for you to write these functions in Lua if you're not comfortable with C++ or if you don't have an account on the appliance, but this requires Netezza Analytics to be installed.

Carl
  • 171
  • 4