|
"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 08/17/2019
04:29:55 PM:
On the other hand, REXX and SQL are indeed a wonderful match. You can
use SQL within a REXX procedure and then call CL statements. REXX
allows you to execute SQL statements (including fetch from a cursor in a
loop) and then use the returned variables in CL statements.
Don't get me wrong... I love REXX. I've used it extensively in
all four IBM host environments -- VM/CMS, MVS/SP, VSE/SP, and OS/400. In
terms of being well integrated, the order given is also a measure of how
well integrated REXX is with the host environment mentioned. (Sorry, not
versed in IBM Linux so can't speak to that environment.)
The "problem" in the OS/400 environment is that REXX runs in its
own world and is not easily called from CL or from RPG -- especially if
you want returned information. This is the same problem CL has with SQL
-- or CL with any other specialized language (such as Python, etc.).
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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 [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
