|
midrange.com
And your trigger program can have a time delay on the receive from data
queue. If it times out then it can run the batch process to fill it again.
Why wait until 999999999? If you use hex shouldn't it go from 000000009 to
00000000A, and so forth? Or you could roll your own hex, and use all
letters instead of stopping at F. Regular hex may be easier because of
existing hex math.
Rob Berendt
==================
Remember the Cole!
Jim Langston
<jimlangston@conexfr To: RPG400-L@midrange.com
eight.com> cc:
Sent by: Subject: Re: duplicate
record Id's in multi user environment
owner-rpg400-l@midra
nge.com
10/16/00 10:51 AM
Please respond to
RPG400-L
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
+---
+---
| 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
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
