Re: SQL output to Printer - anyway of marking/tagging the spoolfile with the PF name

On 27-Sep-2016 14:25 -0500, Steinmetz, Paul wrote:

[…]
RUNSQL REQUEST(' select ''UPPENFILES'' as MyLib, ''STMTM3P'' as
MyFile, GQBGUN, count(*) as MyCount FROM UPpenfiles/STMTM3P GROUP BY
GQBGUN ORDER by GQBGUN') OUTPUT(*PRINT)

Results with this STRQMQRY […]

All the more reason to just code directly to a custom QMQRY and use the SETVAR for the specific values rather than the string [and worse, escaping the delimiters] that must be modified by whatever means and then specified on that RUNSQL request. Not to suggest there are a lack of slick ways to generate the replacement values in the larger string, but using the RUNSQL is a few levels of indirection; just code directly to a specific QMQRY [and optionally a QMFORM -- though the fact that the query output is already deemed acceptable and already being produced by QMQRY, then that would seem to imply that the Default QM Form already must be acceptable].