Re: RE: "Reference #"

We have several auto-generated unique ID numbers that I handle through 1 field 
files.  I then write wrapper procedures and srvpgms to retrieve the next number 
and increment the file.  Of course a data area would work, this is just the way 
I do it and we've never had a problem.

In mySQL, when I create tables that require these unique values I always use 
the AUTO_INCREMENT feature.

Ciao,
Joel


>It could be a dataarea or a one record file,
>either way,
>lock the dataarea/record for only a few lines of
>code,
>just long enough to get the number, increment, and
>update.