Re: Load CL variables from SQL example

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


Sincerely,

Dave Clark