Re: Load CL variables from SQL example

It's not "call with a parameter list and return a value" easy, but it can be done.  In fact, there's an API (QREXQ) you can use to communicate with REXX via what is essentially a data queue.  More here:

https://www.itjungle.com/2005/10/05/fhg100505-story01/

It all depends on what you're trying to accomplish.


On 8/19/2019 10:28 AM, dlclark@xxxxxxxxxxxxxxxx wrote:

"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