Re: SQL in ACS vs Green Screen

Rob

I hear you and had wondered about that as I replied. My question comes from the job types are different between green screen sql and RSS - the former is interactive in nature, the latter is some form of batch. I might remember wrong but thought interactive tends toward *FIRSTIO and batch-like tends toward *ALLIO - I'm happy to be found wrong, of course.

A database monitor or display of last or whatever statement could help know what really happened.

I don't remember, did earlier versions of RSS go all the way to the end at the beginning?

*Regards*

*Vern Hamberg*

<cid:part1.A2lcgc68.tdI9U4u0@centurylink.net>

On 2/4/2025 9:26 AM, Rob Berendt wrote:

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
athttps://archive.midrange.com/midrange-l.

Please contactsupport@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.