Re: Selecting last of a group of records

[Booth Martin <booth@xxxxxxxxxxxx>]

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