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



Hello Java members

I have a question in regard to the way the Java product handles the
commitment control
every time an SQL statement is issued against the iSeries machine

I am not familiar with the *ISOLATION level properties, *DROP connection ,
.. etc


By comparison only this is what we do in the iSeries:

We issue the STRCMTCTL command and later the COMMIT command

In the iSeries we use the commands

STRCMTCTL with a lock level definition of (only one of the following)



*CHG
Every record read for update (for a file opened under commitment
control) is locked. If a record is changed, added, or deleted,
that record remains locked until the transaction is committed or
rolled back. Records that are accessed for update operations
but are released without being changed are unlocked.

*CS
Every record accessed for files opened under commitment control
is locked. A record that is read, but not changed or deleted,
is unlocked when a different record is read. Records that are

changed, added, or deleted are locked until the transaction is
committed or rolled back.

*ALL
Every record accessed for files opened under commitment control
is locked until the transaction is committed or rolled back.


And at some point in the application program we issue the COMMIT command

And that takes care of everything (providing that there was no need for a
roll back operation) for sake of simplicity

Please let me know how does the Java product handles this commitment
control scenario
and if by chance it gets to run the same command is the iSeries Machine

Thanks for your responses and feedback






Jorge A Moreno
Military Car Sales, Inc
Email: jmoreno@xxxxxxxxxxxxxxxx



This email, including its attachments, may contain information that is
confidential and may be protected by federal and/or state laws and
regulations, or other confidentiality privileges. This email, including
its attachments, may contain non-public information, therefore it is
intended to be conveyed only to the designated recipient(s). If you are
not an intended recipient, please delete this email, including its
attachments, and notify the sender. The unauthorized use, dissemination,
distribution or reproduction of this email, including its attachments, is
prohibited and may be unlawful.

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.