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 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 http://www.powertech.com __________________________________________________________________ Introducing the New Netscape Internet Service. Only $9.95 a month -- Sign up today at http://isp.netscape.com/register 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 http://channels.netscape.com/ns/search/install.jsp
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.