Re: Load CL variables from SQL example

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

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.

I did an article about it way back when:

https://www.mcpressonline.com/programming/sql/techtip-calling-sql-from-rexx

It's not as seamless as embedded SQLRPGLE, but once you understand the 
syntax it's extremely powerful.


On 8/16/2019 11:41 PM, Roger Harman wrote:
> While CL & SQL are not a match made in heaven, I've used the DCLF/RCVF technique in the past.
>
> If you need multiple selects & files concurrently, keep in mind that CL will support up to 5 DCLF's.
>
> If you're talking about a single record result, consider using a command calling an RPG to do the work.  I write a lot of "RTV" type commands to return configuration info to my CL programs.
>
> Roger Harman
> COMMON Certified Application Developer – ILE RPG on IBM i on Power