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