Thanks for the replies. I had already used SQL.
On 11/9/2021 2:40 PM, Reeve wrote:
There are two considerations here: one is execution speed and the other is
"clarity of purpose". The latter term reflects future programmers' ability
to understand what you're trying to do with SETGT and READPE. Assuming you
have (or can) index the field in question, I suggest MAX(your_field) is the
better option because the intent of the code is clear and satisfies the
"clarity of purpose" directive. The SQL approach also eliminates the
dependence on a DDS physical/logical file key structure.
On Tue, Nov 9, 2021 at 10:49 AM 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
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.