Using sequences in V5R4

["Reinardy, James" <jreinardy@xxxxxxxxxxxxxxx>]

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.