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

[CRPence <crpbottle@xxxxxxxxx>]

On 27-Sep-2016 11:31 -0500, Rob Berendt wrote:
> Then there's always
>
>   SELECT "LIB1", "FILE1", Date-field,count(*)
>    FROM LIB1/FILE1
>    GROUP BY Date-field
>    ORDER by Date-field
>  UNION ALL
>   SELECT "LIB2", "FILE2", Date-field,count(*)
>    FROM LIB2/FILE2
>    GROUP BY Date-field
>    ORDER by Date-field
>  UNION ALL
>   SELECT "LIB3", "FILE3", Date-field,count(*)
>    FROM LIB3/FILE3
>    GROUP BY Date-field
>    ORDER by Date-field
>
> and get it all in one spool file.

  That statement is not syntactically correct, not even for COBOL ;-)

  But more problematic is the [possible lack of, or quite likely 
undesirable] collation [per either lack of, or illogical, ORDER BY], 
depending on how the statement is redacted to get past the issue with 
the syntax.