Re: Using sequences in V5R4

[Luis Rodriguez <luisro58@xxxxxxxxx>]

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.