Re: RUNSQLSTM problem

[Richard Reeve <richreeve@xxxxxxxxx>]

--
[ Picked text/plain from multipart/alternative ]

 I would like to see your utility but unfortunately my client is not very good 
about allowing downloads like that.  Thanks for the offer though.  I may take 
you up on it one day.

  Martin Rowe <martin@dbg400.net> wrote: On Wed, 2001-12-26 at 15:39, Richard 
Reeve wrote:
> I had tried that already but don't see anything. Would it be easier
> to do a QMQRY? If so could someone lay out the steps to accomplist in
> QMQRY? I am in a bit of a rush..........What else is new?
[snip]

You could try my EXCSQL tool that uses QMQRY - with just variables in
the QMQRY definition, so you can place any SQL statement into it. Your
example in a CL would be

EXCSQL SQL('UPDATE MDTMASSP SET FORNAM = ''4'' WHERE FORNAM = ''9''')

(have to double up on the quotes as the value is seen by the command as
a string). The package is easy to install and with all the objects (CMD,
CL pgm, QMQRY & UIM cmd help) called EXCSQL easy to move/keep track of.
Get it from http://www.dbg400.net/excsql.html - though there are no
guarantees it will work any better than RUNSQLSTM (just a different
approach to try).

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
[this space for hire] ASCII Ribbon Campaign against HTML mail & news /
\

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





---------------------------------
Do You Yahoo!?
Send your FREE holiday greetings online at Yahoo! Greetings.