Re: Selecting last of a group of records

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

Yes. Well...in timestamp sequence, but that's the same thing.

On 7/3/07, Booth Martin <booth@xxxxxxxxxxxx> wrote:
> (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.