MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » April 2012

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



fixed

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





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact