Re: Must I use OPNQRYF

Well, it's done now and I did an opnqryf. Difficult to justify anything
else in this case. I must say though, I do not consider myself a beginner
in SQL at all. I use it all day every day while querying the database and I
have written a substantial amount of embedded SQL in my RPG programs. It's
not SQL I have a problem with at all, I find that it's the implementation
of it in programs that is difficult. It's rare that the opportunity arises
to use it in old programs without having to rewrite everything. And if
you're writing a new one, RLA very often just comes more naturally.
Besides, if the whole team isn't using it, or worse can't understand it
there seems to be little point.




Le 21 février 2012 19:46, Scott Klement <midrange-l@xxxxxxxxxxxxxxxx> a
écrit :

Hmmm... I didn't think about using SPECIAL files. I guess that makes
sense, but... wouldn't OPNQRYF have been easier, both to code and
understand?

On 2/21/2012 9:34 AM, James Horn wrote:

I had some big level break programs I didn't want to change. I used a
"special file" to use sql to return the records to the main program.

works

great for me. Only needed to change 1 line in the program, the file

spec,

and build a little rpg program to do what the opnqryf (or gsort or

#gsort)

did before.

--
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.