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
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
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.