Re: runsqlstm -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

On Thursday 18 July 2002 10:08 pm, James Rich wrote:
> I'm trying to use runsqlstm in a cl program.  I run into trouble with
> the source member that contains the sql statement I want to run.  It
> seems that no matter what I do, it fails with the message (in my
> spooled file result):
>
>  MSG ID  SEV  RECORD  TEXT
>  SQL0084  30       1  Position 7 SQL statement not allowed.
>
> (or whatever position I put things in.  7 is just my latest attempt.)
>
> Anyone know how to make this work?
>
> James Rich

Hi James

What is the SQL statement you're trying to run? RUNSQLSTM doesn't allow
the use of SELECT, and has some other limitations IIRC. You could have a
look at http://www.dbg400.net/excsql.html as an alternative, if you
require SELECTs.

Regards, Martin
--
martin@dbg400.net  jamaro@firstlinux.net  http://www.dbg400.net    /"\
DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open    \ /
Source free test environment tools and others (file/spool/misc)     X
Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news  / \

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.