×
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.
I know I'm joining in quite late, and in all likelihood the actual
task which prompted this thread is long completed. Still, I wanted to
mention another approach for anyone who stumbles across this problem
in the future:
What I would do is to resort to a very high-level language, such as
Python. Other modern scripting languages (such as Perl or Ruby, and
I'm sure there are plenty more) should work just as well, but I
specifically mention Python because there is a native iSeries version,
at <
http://www.iseriespython.com>.
For fun, I wrote a program for this in iSeries Python:
<
http://code.midrange.com/5f79a99cc2.html>
It's similar in length to Richard Casey's clever SQL solution, but for
those (like me) who lack the SQL-fu, the Python is easier to read and
write, and generally more sanity-preserving.
For those who are more comfortable with other scripting languages, it
would probably be worth it to just dump the data out to your Linux box
or PC, and then use the language of your choice there.
John
midrange.com
