Use a Common Table Expression to order file 1 in the preferred sequence,
then join to the CTE, returning the matched rows as one long record that
is mapped into two data structures then make comparisons between the
two data structures ?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave
Sent: Thursday, March 08, 2012 6:57 AM
To: Midrange Systems Technical Discussion
Subject: sql v opnqryf

Hi all,

I want to compare two files : the results of a test against the results of the last test. We have an old home utility that generates an rpg matching record program. When there are key fields in both ascending and descending order, we use opnqryf in a clp that calls the rpg to temporarily reorganize the files so that matching will work.

How could this be done in sql?

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 at

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by 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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.