AW: Formatted UUID from RPGLE

Hi,

To convert a string into hex, just use the SQL scalar function HEX
Exec SQL :MyString = HEX(:ResultUUID);

Yet an other idea, do you really need the result of GENUUID or do you simply
want to create a value that is unique?
If you only need a unique value, you may have a look at the SQL function
GENERATE_UNIQUE, that was introduced in release V5R4.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces+hauser=sss-software.de@xxxxxxxxxxxx
[mailto:midrange-l-bounces+hauser=sss-software.de@xxxxxxxxxxxx] Im Auftrag
von Walden H. Leverich
Gesendet: Saturday, August 25, 2007 00:41
An: Midrange Systems Technical Discussion
Betreff: Formatted UUID from RPGLE


I know I can create a UUID using the _GENUUID mi function, and as expected,
that will return a 16-A field w/a UUID in it. However, I'd like to store
that as a character string in a table, preferable with the "standard" format
of xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, like:
C7408D2A-973C-432A-A31A-ED98A88A9115, but just as hex characters would be ok
too, no dashes. Anyone have a simple way to accomplish this?



Thx,

-Walden