RE: QMQRY runs interactively but not in batch (THANKS!)

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

Peter

You seem to have run into a couple of the restrictions when converting
queries to QMQRYs. As you noted, the output options are ignored. Normally
you should've been able to use OUTPUT(*OUTFILE) on the STRQMQRY command,
but you mentioned summary output. that didn't seem to work when using
STRQMQRY OUTPUT(*OUTFILE). You might be better served, as suggested, to
RTVQMQRY, then modify the resulting statement to have GROUP BY clauses and
summary functions in the SELECT list.

BTW, you don't need to have the SQL licensed product (although most do,
these days) to create QMQRYs. You can edit the source member that results
from RTVQMQRY, then use CRTQMQRY. There's even a WRKQMQRY command to help a
little. I've created some PDM options for the CRTQMQRY and CRTQMFORM commands

Good luck

Vern

At 02:06 PM 8/21/02 -0400, you wrote:

>I will propose management the alternate solution of retrieving the QRYDFN into
>our source file for *QMQRY's and use it as such.