Re: Calling all math wizards

A nice way will be to enumerate the users with the SQL Sequence object

create sequence emp_seq as integer ;
insert into emp_xref (compnum, divnum, empnum, unique_emp) select comp,
div, emp, next value for emp_seq from emp_file;

see
http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/db2/rbafzmstdatetimearith.htm#seqref

Shalom


On 22/10/2007, Elvis Budimlic <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

GENUUID MI instruction generates a 16 byte value that is unique across
space
and time.

Elvis

2007 System i Fall Technical Conference | Orlando | November 4-7
Celebrating 10-Years of SQL Performance Excellence on IBM i5/OS and OS/400

-----Original Message-----
Subject: Re: Calling all math wizards

<snip>

If you can make it work, good luck. I've not seen a good way of
implementing a unique, sequential numbering scheme across multiple
machines and databases.

</snip>

--
Ron Adams
--

--
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.