RE: runsqlstm

[vhamberg@xxxxxxxxx]

I've never understood this limitation. But I usually use
QMQRYs for this - you don't even need the Query
Manager/SQL development Kit for this. Just put your
statements into a source member (RCDLEN(91)) and run the
CRTQMQRY command. Then execute it with the STRQMQRY
command. You can even use substitution variables. This
is how a number of the RUNSQL apps work - the QMQRY is
all substitution variables.

You can also get SQL source from existing QRYDFNs.
RTVQMQRY is the ticket here.

You can also direct the output of STRQMQRY to the
screen, to print, or to an output file. Print output is
better than with interactive SQL, because it will create
multiple sets when the output data is wider than the
prtf record length.

You can have only one statement per QMQRY. However, you
can create QMPRCs (QM procedures) that can run multiple
QMQRYs, as well as set variables, etc.

Check out the Query Management Programming manual at
your local InfoCenter under Database.
> On Thu, 18 Jul 2002, Buck Calabro wrote:
>
> > >It seems that no matter what I do,
> > >it fails with the message (in my
> > >spooled file result):
> > >
> > > SQL0084 Position 7 SQL statement not allowed.
> >
> > I looked at the documentation but could not find the restriction.  You
> > cannot run a SELECT statement.  That's my guess.
>
> It turns out that the select limitation is what I was running into (I did
> finally find the docs that say this).  Anyone know why there is this
> (stupid) limitation?  Why wouldn't I be able to do a select?
>
> James Rich
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>