RE: Commitment Control

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

Rob,

We are currently on V5R2.  Are sequence objects new with V5R3?  I have
used them with Oracle, but never thought of looking for them in DB2 for
some reason.

Thanks,

Jim 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, May 05, 2005 5:08 PM
To: Midrange Systems Technical Discussion
Subject: Re: Commitment Control

What version of OS/400 are you using?
Why not use a Sequence object?
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/db2/rb
afzmstdatetimearith.htm#seqref

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Reinardy, James" <jreinardy@xxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/05/2005 04:58 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Subject
Commitment Control






Looking for some advice.  We have an application that uses a table entry
to get the next available number for an ID field used in a series of
tables.  This number is used in both an RPG and a Java program, and we
are concerned about ensuring that the same number is never issued twice.
My thought was to write a user defined SQL function that would increment
the table value and return the next number, using commitment control to
ensure that the row was locked for the entire process.  We got the
function created, then figured out that we needed to journal the table
in order to use commitment control.  We are not journalling anything on
the box today for performance and data storage reasons and at this point
would prefer to avoid it. 
 
Is commitment control overkill in this case?  We are using an update
cursor to perform the operation, so will that keep the record locked for
the duration of the function execution?  If not, is there another way to
do this gracefully without commitment control and journalling?
 
Thanks in advance,
 
Jim Reinardy
Badger Meter, Inc.
Milwaukee, WI
-- 
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.


-- 
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.