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 

Tom Liotta

midrange-l-request@xxxxxxxxxxxx wrote:

>   8. subject: SQL Vs. RPG Opinions (Dave Odom)
>message: 8
>date: Fri, 19 Mar 2004 12:01:50 -0700
>from: "Dave Odom" <Dave.Odom@xxxxxxxxxxxx>
>subject: subject: SQL Vs. RPG Opinions
>Something to consider...
>In addition to what most of the folks said about the power and
>flexibility of SQL you can combine it with REXX and get all the
>capabilities of SQL with the strength of a programming language that
>doesn't have to be compiled but runs very fast none the less.   Most of
>the IBM mainframe operating systems have used REXX for years with SQL to
>do most anything with DB2.   In the case of REXX, you can use it with
>the native iSeries flat file system or with the true DB2/400 relational
>structures.   Most folks on the other IBM platforms use REXX to create
>simple or complex utilities
>On the iSeries you can also create a command file (QCMDSRC) that calls
>your REXX program and invoke the programs like you use CL to call RPG,
>except you only have to "compile" the CMD file once, unless you change
>the name of your REXX EXEC, and then you can make changes all day long
>to your REXX EXEC and quickly test those changes by invoking the CMD
>file.   Its a very quick and powerful way to create programs.   And if
>you need to do all kinds of concatenations, string manipulation, matrix
>programming and much more, REXX can't be beat.   Lastly, the structure
>of its programs are free-form, no more worrying about getting the
>statement pieces in certain columns.   You can create any kind of
>program from simple utilities to more complex applications with REXX.
>There are a gazillion books out there on how to program in REXX.  The
>one's from IBM are good, especially if written by Mike Colishaw, the
>creator of REXX.

Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904

Introducing the New Netscape Internet Service. 
Only $9.95 a month -- Sign up today at

Netscape. Just the Net You Need. 

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at

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.