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