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