Re: CL & SQL

[Pete Massiello <pmassiello@xxxxxxxxxxxxxxxx>]

This maybe a long shot, but I remember from upgrading a few systems to V4R5,
there was something in the upgrade guide about the use of Local and Global
Variables.  Sorry can't be more specific, but perhaps its worth getting the 
guide
to see what was said.

    HTH

            Pete Massiello

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

--
Pete Massiello
OS Solutions International
Phone: (203)-744-7854  Ext 11.
http://www.os-solutions.com
mailto:pmassiello@os-solutions.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
+---