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  /
\



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.