× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.