> From: David Morris
> I think we agree that SQL is a shoehorn. I also think that
> opnqryf is a shoehorn. So far, I think I am the only one to
> propose a strait RPG method so since you ask, I think
> it is likely to be as good or better than any solution involving

Why is OPNQRYF a shoehorn?  It's a way to dynamically create a logical view
for those situations where you don't want a permanent view.  Think of it
this way: by far the easiest solution to implement would be to have a
logical on the file in descending dollar amount.  If there happened to be
such a logical file, you could skip the OPNQRYF.  However, if there isn't
one, OPNQRYF is an excellent tool.  There is nothing kludgy or shoehorn
about the ability to create a temporary logical based on runtime values.

I fail to see why a one-line OPNQRYF and four lines of RPG is a bad thing.
I mean, having opinions is one thing, but please, back them up with some
sort of concrete argument.  Lines of code would be good.  Simplicity would
be good.  Performance would be good.  "I don't like OPNQRYF" isn't a valid
reason.  The fact that programmers think it's okay to use their favorite
tool rather than the right tool is one of the reasons so much bad code gets

It's just my opinion, and if you don't like it, you're in popular companys.
Hey, that's why my boss is such a jerk.

Joe Pluta
Pluta Brothers Design

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-2022 by midrange.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 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.