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

On 27-Sep-2016 12:09 -0500, Steinmetz, Paul wrote:

[…]
SELECT "pflib", STMTM3P, Date-field, count(*)
FROM Library/PFfile
GROUP BY Date-field
ORDER by Date-field
[…]

Above statement was redacted; this text replaces the comment that explained that\how the original statement from the OP was not the actual statement with the following error msg SQL0206:

Column or global variable STMTM3P not found.

The suggested value was shown to be coded as a string-constant [aka a string-literal] value, for which the apostrophe as delimiter is required; for file named STMTM3P in library PFLIBNAME, the following request should function without error:

SELECT 'PFLIBNAME', 'STMTM3P', Date_field, count(*)
FROM PFLIBNAME / STMTM3P
GROUP BY Date_field
ORDER by Date_field

Note: the value could be established as\from a variable, as an alternative way to resolve the sqlcode=-206; ask if that is of interest and not understood