Re: sql v opnqryf

I was just idly wondering if I could replace the opnqryf and/or the rpg.
Anyway, I did the opnqryf, put all the keys in ascending order and got an
input output error from the rpg that I didn't understand. Apparently the
key of the file was different from the key of the file that was already
opened.
I ended up copying the dds of the file into my test library, changing the
field to ascend, which does not alter the level, and using chgpf before
running the matching record program. What a bodger!

Le 8 mars 2012 15:41, sjl <sjl_abc@xxxxxxxxxxx> a écrit :

IMO before offering any advice I would need for Dave to clarify some
ambiguity in his question.

Dave:
Do you want to /replace/ the matching-record logic program with a SQL file
comparison, or do you want to only replace the OPNQRYF step in the job with
SQL ?

If you are trying to go pure SQL to join and compare the files, having
duplicate keys in the files will be a problem.

- sjl


Gary wrote:
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 ?


Dave wrote:
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?

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.