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:

On 27-Sep-2016 14:19 -0500, Charles Wilt wrote:

Most custom RUNSQL commands I've seen use QMQRY in the background.
<<SNIP>>

You are right, as can be seen from the joblog.

The below RUNSQL

RUNSQL REQUEST(' select ''UPPENFILES'' […]

Results with this STRQMQRY

OVRPRTF FILE(QPQXPRTF) TOFILE(*LIBL/QPQXPRTF)

STRQMQRY QMQRY(RUNSQL) OUTPUT('*PRINT')
ALWQRYDFN(*YES) SETVAR((LINE01 '
select ''UPP') […]

Hmm. Makes me wonder how the topic started off with the QPQUPRFIL Printer File.?

Oh, BTW, while unlikely ever either to result in a problem or an otherwise confusing effect [from the perspective of a user], I do see that the particular version\implementation of RUNSQL used in the above, has a potential for anomalous effect per the *YES specification on Allow Query Definition; the presumed-expected value would be *NO.