Re: time/date as key fields

Crispin,

its definitly not unique. the documentation is not really clear, it says most likely unique. I've tried to adress this in as400.misc, but didn't get exact response there too. So I did test it on my own and I've got duplicate values on a fast multi processor iron in a massive parallel scenario.

Dieter

--------------------------------------------------
From: "Crispin Bates" <cbates@xxxxxxxxxxx>
Sent: Friday, November 19, 2010 4:19 PM
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Subject: Re: time/date as key fields

Dieter,

Do you have any reference that says that a UUID from _GENUUID is not unique?

http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/index.jsp?topic=/rzatk/GENUUID.htm
says it is.

Are you saying it is not?

Thanks,

Crispin.

----- Original Message ----- From: <dieter.bender@xxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, November 19, 2010 9:07 AM
Subject: Re: time/date as key fields

... it depends, maybe for referential constraints, if there are database
relations.
BTW: genUUID on AS/400 is only most likely unique!!! Best choice would be
an
identity column, if uniqueness is needed.

D*B

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.