× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



We have a requirement to print multiple variations of an aging
report, giving users 4 different sort groups.  The matrix looks
like about 80 combinations.

The users will have an input screen of some kind to define their
sort definitions.

Right away, I thought OPNQRYF using variables might do the trick.
Ugly IMHO but effective.  Then I wondered aloud if SQL would be a
better avenue.  We almost certainly have partial paths out there,
so we do not start from zero, but then again it could also get ugly.
Also, the ability to save at least a definition (even better, a full
path) would be an attaboy.

Trying to weigh the maintainability versus the performance, and looking
for suggestions.

TIA

Dan Rasch - because if the human species concentrated on the really
important things in life, there would be a shortage of fishing poles!
IBM Certified twice....... but still a couple PTFs away from Nirvana.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2024 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.