Re: SQL in ACS vs Green Screen

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

My usual questions would resolve around possible record locking and stuff
like that.  Could be a coincidence of timing.

On Tue, Feb 4, 2025 at 10:04 AM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxxxx>
> 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.