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

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


(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)
[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 thread ...


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.