Re: Select Max value question 2

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

I concur - SQL does not guarantee that rows are returned in any order 
unless you specify the "order by" clause. Different environments can 
result in different results.

Cheers
Vern

On 5/30/2018 8:52 PM, paultherrien@xxxxxxxxxxxxxxxxxx wrote:
> 'Order by' clause?
>
> Sent from my Verizon HTC Smartphone
>
> ----- Reply message -----
> From: "Art Tostaine, Jr." <atostaine@xxxxxxxxx>
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> Subject: Select Max value question 2
> Date: Wed, May 30, 2018 9:47 PM
>
> Do I have to do anything to clean up when I run multiple Select into
> statements in an RPG program?  I'm seeing joblog messages like ODP not
> deleted.
>
> My RPG statement looks like this:
>
> exec sql SELECT cls, max(qty) into :pkgGroup, :wkqty
> from whso313f
> where sty = :pkgStyle
> group by cls
> fetch first row only;
>
> The wrong result CLS = 4 is returned, verified with debug and it's being
> written to another table.
>
> If I break before that statement, and F3 and then run the statement on
> STRSQL, I get the correct answer, CLS = '2'