Re: Selecting last of a group of records

<snip>
uniquely identifies the last group - there may be many groups with the
same order number. I was thinking of using a scrollable cursor, going
to the end, then fetching prior. But then I though I could load the
data into a MODS and do the same logic in my program without the fetch
prior. Any ideas? Thanks...
</snip>

Another solution would be to combine both and put the result of an SQL
into a user space and map the user space to a either an array or
multiple occurrence data structure so

Exec Sql Fetch Next From C1 Into :Array For 32766 Records;

If SqlState <> '00000';
w_RowCount = SQLERRD(3)
EndIf;

You can then just read the array from the last record.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.