Re: duplicate record Id's in multi user environment

[Jim Langston <jimlangston@xxxxxxxxxxxxxxxx>]

Hmm... This sounds like an idea...  If the batch job keeps the data queue
filled with, say, at least 1000 entries, it shouldn't be a problem.  It 
would be possible for a program to grab an entry and not use it (the job
bombs out, user turns off tube, etc...) but this shouldn't be a problem
as we are not really looking for sequential numbers, just unique ones.

Of course, the key field in the data files should be declared as character
fields and not numeric (no math is ever going to be performed on them) which
gives us a lot of advantage.  One of the biggest ones being that once you hit
999999999 you can start over at, say, A000000001.

And even at this, a trigger program can be used to pull the number from the
data queue, so you only have one place to modify the changes.

Regards,

Jim Langston

Steve Brazzell wrote:
> 
> Seth,
> 
> Remarkable, but I was just thinking the same thing.  Also, if after each
> receive from the queue an increment and send were done, even the batch
> feeder job wouldn't be needed.  Of course, that brings up the problem of a
> program somehow failing between the receive and send, but still an
> interesting idea, imo.
> 
> Steve Brazzell
> Innovatum, Inc.
> 
> -----Original Message-----
> From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
> Behalf Of Seth.D.Shields@blum.com
> Sent: Monday, October 16, 2000 1:45 PM
> To: RPG400-L@midrange.com
> Subject: Re: Re[2]: duplicate record Id's in multi user environment
> 
> Just an idea.  How about a batch job feeding sequential Order #'s to a data
> queue.  When a job needs a Order number, it just pulls
> the next one from the queue.
> 
> Regards,
> Seth Shields
> Julius Blum, Inc
+---
| 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
+---