-- [ 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 <firstname.lastname@example.org> 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 -- email@example.com firstname.lastname@example.org 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-Lemail@example.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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.