Latest version of RDI / SQL in ACS vs Green Screen

Good morning all.
Our developers were using RDI V9.6. I was able to bring in RDI V9.8 without issue or cost.

Have never experienced what Greg is describing as far as ACS SQL performance and STRSQL performance.
They've always been equal when I've run an SQL statement either way.

I'm on V7R4, PTF's not quite current.
Power 10, NVMe disk.


Respectfully,
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Cell, Office and Text Messages: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx
https://www.ermco-eci.com
https://ermcopower.com/
IBM i Award Winning Blog Site: https://ibmireference.blogspot.com
Awarded IBM 2024/2025 Advocate, Contributor, Influencer and IBM i Ready Badges.



Today's Topics:

2. Latest version of RDI (Bill and Lisa Howie)

4. SQL in ACS vs Green Screen (Greg Wilburn)


----------------------------------------------------------------------


------------------------------

message: 2
date: Tue, 4 Feb 2025 14:16:44 +0000
from: Bill and Lisa Howie <blhowie66@xxxxxxxxxxx>
subject: Latest version of RDI

Hello all,

I have a fully-licensed and paid-for version 9.6 of RDI. Anyone know if I'd be entitled to the latest 9.8 version for no cost or would I have to buy it again?

Bill

------------------------------

message: 4
date: Tue, 4 Feb 2025 15:04:29 +0000
from: Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
subject: SQL in ACS vs Green Screen

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