× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. August 2007

RE: STRQMQRY QMQRY(XV0001_Q01) OUTPUT(*PRINT) + STRQMQRY QMQRY(XV0001_Q01) OUTPUT(*PRINT) + STRQMQRY QMQRY(XV0001_Q01) OUTPUT(*PRINT) + SQL works in iNav but not QMQRY

<snip>
I've got a pretty long SQL statement that works in iSeries Navigator's
run SQL scripts, as well as in the 5250 STRSQL. However, it does not
work when compiled as a QMQRY. (We're using QM queries because we need
to pass a couple of parameters.)



Here are the messages I receive:

STRQMQRY QMQRY(IMDMDCMPQM) SETVAR((DMD_C 001486) (DMD_P 001487))
</snip>

I believe your problem is that the strings are not quoted. Here is some
CL that I use. This assumes that the fields in question are strings.

DCL VAR(&QUOTE) TYPE(*CHAR) LEN(1) VALUE('''')

STRQMQRY QMQRY(XV0001_Q01) OUTPUT(*PRINT) +
QMFORM(XV0001_Q01) DATETIME(*NO) +
PAGNBR(*NO) SETVAR((JOBNAM (&QUOTE || +
&JOBNAME || &QUOTE)) (USRNAM (&QUOTE || +
&USERNAME || &QUOTE)) (JOBNUM (&QUOTE || +
&JOBNUMBER || &QUOTE)) (SEVERITY (&QUOTE +
|| &SEV_CHR || &QUOTE)))


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