On Nov 9, 2021, at 1:49 PM, Alan Cassidy <cfuture@xxxxxxxxxxx> wrote:
i'm using SQL to get the maximum value for a field meeting key field WHERE comparisons into an RPG variable.
I'm replacing code that used the SETGT with READPE to find the maximum value.
I'm wondering which method shows better performance if somebody knows. I was told once that single-value CHAIN trumps using SQL to get one value for one composite key. But time has passed and IBM keeps on juicing up the SQL engine...
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.