Generate a Unique ID

[Manoj Chaurasia]

hI,

 

I Have a requirment where my BW process will use the library file developed by me.I want to generate a unique Transaction ID

to keep track of my Main BW process.How can this be generated

 

regards

[Mathieu Delporte]

Hi,

 

There is a lot of solution (each one have its own advantages and drawbacks) :

- Using an oracle sequence,

- Creating the ID with a timestamp + some rand value (increase the size of the rand value if you want to decrease the chance to have the same ID generated),

- The same thing than above but with a critical section to avoid "concurrent" use and thus decreased again the probability of having the same ID,

- Using a field of your business data which is already unique,

- ...

 

regards,

mathieu

[Issam Ressani]

you can use UUID() function.

[Marcio Souza 2]

Whould you have an exemple on how to use UUID() Function