Re: SQL in ACS vs Green Screen

Vern,
I understand what you are asking but I am not sure it is a valid concern.
Run SQL Scripts does not jump to the end either. They have a special icon
at the bottom right for that.

On Tue, Feb 4, 2025 at 10:18 AM Vern Hamberg via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi Greg

When you say that green screen version shows results within seconds, do
you mean the first screen, or the entire result set? If the former, how
long does it take to go to the end in STRSQL?

*Regards*

*Vern Hamberg*

<cid:part1.yruwZGKv.v1psmWHL@centurylink.net>

On 2/4/2025 9:04 AM, Greg Wilburn wrote:

I just observed the oddest thing... I have several SQL statements that

aren't terribly complex. However, they would not finish in ACS (would not
show any results and ran for almost an hour).

If I copy the same SQL statements into the green screen STRSQL, they

show results within seconds.

I ended the QZDASONIT jobs after canceling the action in ACS. I also

restarted the ACS Run SQL scripts application.

Anyone ever encounter this?

TIA
Greg
[Logo]<https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@totalbizfulfillmentcom>
1 Corporate Dr
Grantsville, MD 21536
www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.