Re: Selecting last of a group of records

(In other words you want the last group of records, in arrival sequence?

Michael Ryan wrote:
> It's the group with the highest timestamp...the records would look like this:
>
> 2007-06-13-06.50.51.725000 ORDERH 114938 VYM1
> 2007-06-13-06.50.52.829000 ORDERD 114938
84598
> 2007-06-13-07.04.28.104000 ORDERH 114938 VYM1
> 2007-06-13-07.04.29.214000 ORDERD 114938
84598
>
> Two groups, each consisting of one header and one detail. If the
> timestamps were the same within a group, I could use that. I guess I
> could find the highest timestamped header and then grab all the detail
> after that.
>
> On 7/3/07, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
>
>> If there's nothing that defines the last group of records, including the
>> order number, then, no.
>> What is your definition of the last group of records? Even if you can't
>> define it in computerese...
>>
>> Rob Berendt
>> --
>> Group Dekko Services, LLC
>> Dept 01.073
>> PO Box 2000
>> Dock 108
>> 6928N 400E
>> Kendallville, IN 46755
>> http://www.dekko.com
>>
>>
>>
>>
>>
>> "Michael Ryan" <michaelrtr@xxxxxxxxx>
>> Sent by: midrange-l-bounces@xxxxxxxxxxxx
>> 07/03/2007 11:44 AM
>> Please respond to
>> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>>
>>
>> To
>> "Midrange Systems Technical Discussion" <MIDRANGE-l@xxxxxxxxxxxx>
>> cc
>>
>> Fax to
>>
>> Subject
>> Selecting last of a group of records
>>
>>
>>
>>
>>
>>
>> I have a file that contains order header and order detail. These
>> records will always be in the proper order: 1 order header record with
>> 1-n order detail records. I have an index over the data so record
>> retrieval by order number is very fast. Using embedded SQL, is there
>> any cool way to get the last group of records? There's nothing that
>> 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...
>> --
>> 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.
>>
>>
>> --
>> 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.
>>
>>
>>

--
---------------------------------
Booth Martin
http://www.Martinvt.com
---------------------------------

--
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.