RE: Load CL variables from SQL example

You got lots of good suggestions but basically what it boils down to is that CL doesn't receive SQL variables directly and never will. Every RFE to get it to do so gets denied.

While it may be a pain to write RPG to do simple Control Language stuff you're less likely to find yourself trying to shoehorn function into CL later on. Way back when CL was getting next to nothing in the way of enhancements I abandoned it for RPGLE.
Sure, CL may have been nice with it's MONMSG after a command capability. And, until IBM started pumping out all those cool IBM i Services, you had to use APIs as a replacement for many commands.

Another alternative is to just use mixed languages. Like CL for what it's best for and RPGLE (or your preference) for what it's best for. Some call this part of modularization.

Rob Berendt