Re: duplicate record Id's in multi user environment

[rob@xxxxxxxxx]

I've used trigger programs to record the user, and the timestamp, into a
file.  After having been caught in error once today, I'd hate to give
misleading info again, but, you may want to test that the timestamp carried
out into the microsecond.  I am pretty sure, (notice the confidence lost?),
that there are some instances in which microsecond may not get filled in.
However I checked out my example and it seems fine.



                                                                                
                                       
                    "Peter Dow"                                                 
                                       
                    <pcdow@MailAndNew        To:     <RPG400-L@midrange.com>    
                                       
                    s.com>                   cc:                                
                                       
                    Sent by:                 Subject:     Re: duplicate record 
Id's in multi user environment          
                    owner-rpg400-l@mi                                           
                                       
                    drange.com                                                  
                                       
                                                                                
                                       
                                                                                
                                       
                    10/12/00 12:08 PM                                           
                                       
                    Please respond to                                           
                                       
                    RPG400-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       




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



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