I'm not exactly clear why you need to use Remedy's GUID. On MS SQL server you could use the NewID() function to generate a unique ID On MySQL you can use UUID() function Either one of those will give you a "Unique" ID to work with.
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Craig Carter Sent: Wednesday, December 30, 2009 2:57 PM To: [email protected] Subject: Re: Q: GUID Generation We're actually on SQL Server and they are on MySQL and we can't use a simple sequencer anyway. After reviewing GUID and UUID, there are several variances on this and I'd like to basically duplicate what the BMC/Remedy function does rather than have them call a Remedy web service and pass one back. We're basically migrating certain processes to another system but keeping them integrated so it would be easier if their system could generate a like value going forward. Craig Carter Information Technology Manager, RSP -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, December 30, 2009 1:49 PM To: [email protected] Subject: Re: Q: GUID Generation ** Hi, I don´t know, what you want to do with this information. But you can also use the sequence generation function of the database (Oracle). Cheers Tristan -----Original Message----- Date: Wed, 30 Dec 2009 21:28:07 +0100 Subject: Q: GUID Generation From: Craig Carter <[email protected]> To: [email protected] ** _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ Anyone know if the actual code behind "Application_Generate_GUID" is available anywhere? We need to try and duplicate this functionality in a different system for integration purposes and wondered if this information is available anywhere? Regards, Craig Carter Information Technology Manager, RSP _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
