Yep, my suggestion assumed something like those commands had been run to an outfile - glad you amplified on it, of course.

On 9/28/2012 12:27 PM, Jack Kingsley wrote:
have you looked at any of the dspjrn/cvtjrn type commands. Maybe you could
parse out what you want to a file, then go after what you need from there.

On Fri, Sep 28, 2012 at 1:09 PM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>wrote:

Hi Joel

A quick thought - use a UNION SELECT. This assumes you have some
criteria for the particular set of records - the first SELECT would get
the record with some minimum timestamp, the second SELECT would get the
record with some maximum timestamp.

I'm just flying off the cuff with this - not sure it'd work at all -
depends on how the data comes out. It'll work in a general sense, though.


On 9/28/2012 10:32 AM, Stone, Joel wrote:
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 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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

This thread ...


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