I'm glad to see that someone else has experienced the power and
capabilities of REXX.   Most likely, the reasons why the DB2 for AS/400
SQL Programming book has not been updated in ages, are:

1. Most folks on iSeries have not gone outside the box of CL, as it is
what they learned and works 
2. REXX has been around for years and is a rock-solid and
mission-critical-capable EXEC language which has not needed any

And to what you said: "The power of REXX combined with the power of SQL
allows lots of interesting stuff.",  your absolutely correct and an
example is doing matrix work as well as all the other things I


Dave Odom

Also, from the REXX reference:

"Note:  To use the EXECSQL environment on a system that does not have
the DB2/400 Query Management and SQL Development Kit Version 2 LPP,
5763-ST1, installed, see the DB2 for AS/400 SQL Programming for special
instructions for handling the REXX program."

That's from the section on ADDRESS with EXECSQL. It hasn't been updated
in ages, but seems to hold true into OS/400 version 5. There appears to
be zero documentation beyond the notes in the REXX Reference; DB2
manuals don't mention it, AFAIK. A call to IBM a number of months ago
led nowhere except "It's seems to work on our systems."

And it works here.

The power of REXX combined with the power of SQL allows lots of
interesting stuff.

Tom Liotta

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