RE: SQL in ACS vs Green Screen

Thanks for the replies...

I will compare the configuration... I may have change the sort sequence in ACS for another project.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Martijn van Breden
Sent: Tuesday, February 4, 2025 10:59 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL in ACS vs Green Screen

Hi Greg,

I would suggest you take a look at the configuration of your ACS SQL session and 5250 SQL session. Things like naming conventions and so on might make a difference. I once experienced some very peculiar differences caused by the type of activation group inv olved (single level storage versus teraspace).

There's of course also the Plan Cache that may uncover differences between the execution in 5250 and ACS.

Hope this helps


Kind regards



Martijn van Breden

lead software architect



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?


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

Greg Wilburn
Director of IT
301.895.3792 ext. 1231