Most OSs have a call available for generating a UUID (Universally Unique ID) or
GUID (Microsoft's acronym for Globally Unique ID). By definition and accepted
generation standards these are almost guaranteed (!) to be unique (the
probability of a clash is extremely small) across all computers.
In UV you could use GCI to create a UV verb to invoke the OS call. Or just
create a VOC item which you can execute and capture. There are usually options
which affect the format of the output.
For AIX the VOC item might look like this:
UUID
0001 V
0002 /etc/ncs/uuid_gen
0003 U
0004 CGHIM
For Linux use: /usr/bin/uuidgen
For Windows (not installed by default): guidgen
HTH
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of David Wolverton
Sent: Thursday, 27 January 2011 01:55
To: 'U2 Users List'
Subject: Re: [U2] Data in Dict
I'm curious what your logic is to generate the Unique ID -- can you share that
without giving away a trade secret??
It's too bad it's not a database function call in UniData/UniVerse - we can do
that in D3/Pick - it's a derivation of system Date/Time with AlphaSequencing if
more than 1 hit in a given clock cycle - but it would only be unique on the
'machine' since another system could generate the same ID. So I am interested
in the idea of generating a TRULY unique ID.
DW
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Steve Romanow
Sent: Tuesday, January 25, 2011 7:24 PM
To: U2 Users List
Subject: Re: [U2] Data in Dict
In some cases I am becoming a fan of UUIDs for db table keys. A UUID type one
uses the mac address of the host along with the current time as salt so you
don't have to worry about key collisions between accounts (I.e. TEST and PROD).
Generating the next key is fast because there is no readu, update, write. They
should hash pretty well since they are long and random.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
