Re: Running SQL command in a CLLE program

["Jim Essinger" <dilbernator@xxxxxxxxx>]

Create a QM Qry and pass parms

On 10/18/06, Scott Klement <midrange-l@xxxxxxxxxxxxxxxx> wrote:
> Hello,
>
> On Wed, 18 Oct 2006, "Nandi, Rabindranath \(Cognizant\)" wrote:
> >
> > Is there a way to execute SQL statements in a CLLE programs, other than
> > the following?
> > 1) QMQRY
> > 2) RUNSQLSTM
> > 3) Calling Embedded SQLRPG program in the CLLE program
>
> Lots of ways.
>
> a) You mentioned RPG, but didn't mention any of the other HLLs that can
> have SQL in them. C, COBOL, Java...
>
> b) Starting in V5R3, you can call the SQL CLI API directly from CL.
>
> c) You can call REXX from CL, and do the SQL in REXX.
>
> d) You can call QShell from CL, and do the SQL in QShell.
>
> This is just off the top of my head.  I'm sure there are other ways that
> don't immediately come to mind.  Why do you want to know this?
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.