Re: duplicate record Id's in multi user environment

Hi Ray,

Job number + system time to the microsecond or + a sequence#? A common data
area that you can lock while it is being read, incremented, then updated? Or
Paul's suggestion...

HTH,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax



----- Original Message -----
From: "Ray Nainy" <ray_456@hotmail.com>
To: <RPG400-L@midrange.com>
Sent: Wednesday, October 11, 2000 11:22 PM
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
+---