QZDASOINIT Stored Procedure Running Slow

[henrymiller]

Hello,
I have a weird behaviour on a stored procedure running in QUSRWRK subsystem.
When I run the above stored procedure from ACS(Run SQL Script) it takes 21 minutes to execute.

[ 31/12/2020, 18:49:16 ] Run Selected...
CALL spgetQtyOnHand ('020', '2020-01-01' , '2020-12-31'...

[GPEICM]

Hello to All,
I'm trying to retrieve information from AS/400 in an VBA EXCEL application.
So, I've made an RPG program that return's a parameter, then CLP (calls the RPGLE and returns the parameter) and then a stored procedure which calls that CLP.
That i want to execute in VBA...

[yesosuresh]

Hi Friends,
I've created SQL stored procedures in our development schema and its working fine. Now we are in the task of moving our development codes to production one. How do I copy those stored procedures from one schema to another schema? Do I need to re-compile whole procedures on targeted...

[sidewinds]

Hello,
We've been trying to find info on calling a stored procedure written in RPG from PHP and returning a result set. There is information around, but it's kind of scarce to find one solid example of doing this.
Basically we want to do some processing in an RPG program and then send...

[neo85]

Hi there, I am working on a small web application that runs on IBM Websphere and calls AS/400 stored procedures for database access. Since the code was written long back, I had to do some performance tuning on the existing AS/400 RPGLE coding. 1. Can you guide me on the coding practices that s...