Is it possible (and simple) to select only two records from the journal - for each file-RRN combination?


Users make 20 changes throughout the day to CUST #123 record.

I want to select only the first "before" image and the last "after" image for that particular cust (and all other custs).

Can SQL select these with a simple statement?

Or is this best done in an HLL pgm?


This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page