Re: duplicate record Id's in multi user environment

[booth@xxxxxxxxxxxx]

Consider using a random number generator to generate numbers.  The chances 
of 10 people picking a same number are remote.   A second choice might be 
to send the new record onto a data queue and have a single-purpose program 
that sits there waiting for records off the queue, adding an ID#, and 
doing the actual record creation.


_______________________
Booth Martin
Booth@MartinVT.com
http://www.MartinVT.com
_______________________




"Ray Nainy" <ray_456@hotmail.com>
Sent by: owner-rpg400-l@midrange.com
10/12/2000 02:22 AM
Please respond to RPG400-L

 
        To:     RPG400-L@midrange.com
        cc: 
        Subject:        duplicate record Id's in multi user environment


Hello,

What would be the best way to assign unique record Id's in a multi user
environment? Since, we have about ten users who add records to same file
almost at same time. Chances are high that more than one user try to add a 

record at same time. The file should only have unique record Id's.

Our users access this file through a client server application
(power builder). The client server application calls a stored procedure
written in SQLRPGLE to add the records to file.

Any help is greatly appreciated.

Ray
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: 
david@midrange.com
+---




+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---