The funny thing about Scott's solution is that CL is totally incidental to the process.
It could have been any other language calling the C file procedures.
I don't think the OP should submit this solution as his answer to his homework assignment.

Paul Therrien
Orion South, Inc.
800-437-7173; Ext. 551

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Tuesday, September 11, 2012 6:10 PM
To: Midrange Systems Technical Discussion
Subject: Re: program to read pf in reverse order using cl/400 program

Hi Joel,

I had the impression that the OP wanted this in reverse RRN sequence.
SQL would not be a very efficient way to do that (though, I guess it could work.) I thought record-level access would be better for this sort of thing.

If you really want to see my code, it's here:

There are probably 100 ways it could be improved, but I don't plan to actually use it.

Keep in mind that (as I've already said) I don't think this is a good technique, and I don't really recommend anyone do anything this way. (I can't say that enough.)


On 9/11/2012 11:13 AM, Stone, Joel wrote:
So share how you did this - SQL? APIs?

Hey - someday we may ALL have to take this test to keep our position
that was recently outsourced to an off-shore outfit.

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

This thread ...


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