RE: CL & SQL

[Bill Erhardt <ERHARDT@xxxxxxxxxxxxx>]

I've run into a problem using Query Manager under V4R5.  I've created a few
routines that use the replacement variable feature of QM prior releases but
now I get a run time error that references a problem Local and Global
variable.  Any ideas regarding the problem?
Bill Erhardt
Baldwin Hardware

PS thanks for the RUNSQLSTM command tip.  I've been using SQL on the 400
since 81, I guess even an old dog like myself can learn new tricks.  

> -----Original Message-----
> From: Martin Rowe [SMTP:martin@dbg400.net]
> Sent: Wednesday, May 09, 2001 3:10 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: CL & SQL
> 
> On Tuesday 08 May 2001 22:43, you wrote:
> > Hi All,
> >
> > I'm new to imbedded SQL.  Can SQL statements be executed from within a
> > CL program and if so, what resource should I be looking for to guide me
> > in how to do it.  Thanks.
> >
> > Buzz Fenner
> > mailto:bfenner@jonesborocwl.org
> 
> Hi Buzz
> 
> I don't think there is a CL equivalent to SQLRPG, but there are a few 
> options for running SQL from a CL. As long as you have Query Manager (the 
> existance of STRQMQRY & CRTQMQRY commands should show that) you can use 
> the RUNSQLSTM command to run an existing SQL statement held in a source 
> member. An alternative is to use a third party tool that accepts an 
> ad-hoc SQL request as a command parameter. There are a few of them around 
> including my own EXCSQL (see the Extras section on my home page - see 
> .sig below) that do this fine. It supports output (if any) to screen, 
> report or *OUTFILE.
> 
> Regards, Martin
> -- 
> martin@dbg400.net / jamaro@firstlinux.net
> http://www.dbg400.net  DBG/400 - DataBase Generation utilities 
> Open Source test environment tools for the AS/400 / iSeries and 
> miscellaneous database & spooled file management commands.
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---