Re: CL & SQL

On Wednesday 09 May 2001 13:11, Bill Erhardt <ERHARDT@baldwinhq.com> 
wrote:
> 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

The only QM query stuff I've done is in setting up my EXCSQL tool, where 
the QMQRY just consists of one line &SQL1&SQL2&SQL3... with a CL frontend 
chopping up the SQL request and fitting it into the varibles in a 
STRQMQRY command. We're still on V4R4 at work, and I haven't come across 
any problems with it. I've just thrown a few statements through it on my 
NetShare400 account (running on V4R5) and they worked okay, so not much 
use to you, I'm afraid :-( 

> 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.

I've not used it myself, just seen others mention it here on the list ;-)

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
+---