Re: Selecting last of a group of records

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

Thanks Alan...I wound up doing a fetch of the highest timestamp for a
header record, then did another fetch of all the records with that
order number and the timestamp GE the header timestamp. It worked...

On 7/3/07, Alan Campin <Alan.Campin@xxxxxxxxxxxxxxxx> wrote:
> <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.