How to generate 32 characters unique number

Database
Enthusiast

How to generate 32 characters unique number

Hi,

Can anybody advise "How to generate 32 characters unique number" in Teradata.

I know this can be done in oracle.

Thanks a lot in advance.

Sagar.

1 REPLY
Senior Apprentice

Re: How to generate 32 characters unique number

Hi Sagar,

you need to write a UDF.

Probably the easiest way is to search for an open source C-implementation of a UUID version 4 and wrap this in a Teradata C-UDF.

Dieter