Re: Is there a better way to run SQL in a CL pgm?

LOL - I'm lucky to have flipped the order, then!

I believe that the SQL licensed product (57xx-ST1) has to be installed in order to use the *EXECSQL environment - that may have changed - unlike compiled RPG with embedded SQL - these do not require the licensed product on the system where the program is running.

This would be a requirement that'd make REXX less of a useful alternative, methinks.

HTH
Verh

On 4/9/2012 4:12 PM, CRPence wrote:

On 29-Mar-2012 14:43 , Vern Hamberg wrote:

And REXX can do SQL embedded.

Perhaps worth clarifying, for those less acquainted, that the above
expressed "REXX can do SQL embedded" does not equate with [and should
not be confused with a potential and incorrect inference that] the "REXX
can do embedded SQL":

REXX can perform much of SQL via the *EXECSQL environment and perform
the CL via the *COMMAND environment. Both language environments are
provided within the REXX language, whereby the statements\commands of
those other two languages [as supported by their language environments]
can be _interspersed_ with the REXX language statements. REXX can not
however, do "embedded SQL", because REXX is an interpreted language;
i.e. not compiled and thus there is no SQL pre-compiler for the REXX
language.

Regards, Chuck