What is CVTJRN? Is that never than 5.4? Or a non-IBM product?


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jack Kingsley
Sent: Friday, September 28, 2012 12:27 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL: how to farm journal: select only oldest and newest record for each cust #

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 http://www.symanteccloud.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.

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

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact