Re: duplicate record Id's in multi user environment

["Eric N. Wilson" <doulos1@xxxxxxxx>]

Hello Ray,

Wednesday, October 11, 2000, 11:22:54 PM, you wrote:


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



You could do what we do. Namely make a trigger program and attach it
to the insert event of the file.
Then inside the trigger program
     lock a data area,
     increment the value in the data area
     unlock data area and
     use the new value from the data area as your sequence number.
     Update the after image in the parameters
and that will give you what you need.

Make sure you specify allow repeated change on the addpftrg command.

Works very very well!


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