Re: Calling all math wizards

["Shalom Carmel" <shalom@xxxxxxxxxx>]

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.