Re: Record lock issue - is it JT400 ? -- JAVA400-L

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

When I reviewed the code that is what I thought. So, I went ahead andcommented out the member override method and just let it run against thefirst member which has no data. Yes, it is a multi-member file and itwas created using the CRTPF command using DDS. On the second pass itstill had a lock, after the recordset and statements were closed, butbefore the program ended.


Database Group PTF level maybe?

Pete

David Gibbs wrote:

Pete Helgren wrote:

Here is the entire code. You could probably use your own tablereferences and see if you get the same result.


I just ran the code and the lock went away as soon as the result set was
closed, but I'm not using a multi-member file, so the override was just
done to the main member.

Could have something to do with the fact that you're overriding the
member and not deleting the override?

(BTW, it would be nice to have a "Post Code Snippet" link on the
midrange.com Home page.  I'll be darned if I can find the
instructions on how to do it in the archives...)


I'll see what I can do about that.

david

This mailing list archive is Copyright 1997-2025 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.