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