Great thought process! For those who fall into one of these categories:
- boss won't spring for the imbedded sql precompiler
- won't learn anything new, going to retire in the next 20 years
- if the boss issue, then don't want to learn SQL CLI as a work around
This helps a lot. Put the complexity in a view, and if you just insist on
OPNQRYF then do what's left there. The view can be reused to make queries
easier and whatnot.
This mailing list archive is Copyright 1997-2019 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