AW: Using sequences in V5R4

["Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>]

Jim,

just a question:
Are you using NEXT VALUE FOR SEQUENCE in the select statement AND in the
update/insert statement, too?

If so you determine the next value twice and consequently it always
increments 2.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Luis Rodriguez
Gesendet: Wednesday, 09. March 2011 21:14
An: Midrange Systems Technical Discussion
Betreff: Re: Using sequences in V5R4

Jim,

Are you using a CACHE with the CREATE SEQUENCE statement?


Luis Rodriguez
IBM Certified Systems Expert ? eServer i5 iSeries
--



On Wed, Mar 9, 2011 at 2:49 PM, Reinardy, James
<jreinardy@xxxxxxxxxxxxxxx>wrote:

> We are having issues with record locks on a BPCS table that stores the
> last value for an order number, so we are attempting to use a sequence
> with an increment of 1 instead.  We have been able to create the
> sequence and it works fine when calling it from a SQL prompt.  (e.g.
> Select Next Value for BPCS_ORDER_NUMBER from SYSIBM.SYSDUMMY1) However,
> when called via RPG with an embedded SQL statement of the same syntax,
> it always increments by 2.  Anyone run across this type of issue before?
> We are on V5R4.
>
> Thanks,
>
> Jim Reinardy
> Badger Meter, Inc.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.