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


  1.  Home
  2. MIDRANGE-L
  3. March 2021

Re: SQL Scripts in ACS

This is a common issue with Run SQL Scripts - it just doesn't release the lock after running a statement.

One approach is to run the stop SQL function by itself after you are done with the other statement - this has released the lock, in my experience.

I just tried the menu option to clear all results - no luck there.

On 3/23/2021 10:37 AM, Dave wrote:
Hi all,

I'm testing a program on an ACS 5250 emulator screen. I switch to a SQL
script window to view some results. When I go back to the green screen, I
can't continue to test because my program is trying to do a CLRPFM and the
job running the SQL scripts has locks on the files that I previously
consulted.
I would have thought this was a bug. Can anyone help?
Thanks


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
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.