Manoj Chaurasia Posted January 18, 2011 Share Posted January 18, 2011 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 Link to comment Share on other sites More sharing options...
Mathieu Delporte Posted October 23, 2015 Share Posted October 23, 2015 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 Link to comment Share on other sites More sharing options...
Issam Ressani Posted January 5, 2017 Share Posted January 5, 2017 you can use UUID() function. Link to comment Share on other sites More sharing options...
Marcio Souza 2 Posted May 28, 2020 Share Posted May 28, 2020 Whould you have an exemple on how to use UUID() Function Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now