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

If which date field can be determined from a list of all the date fields in the [record format of the] file, or if there is only ever one date field for the [record format of the] file, then there are numerous ways to obtain the column name(s) to enable making that substitution.
Although just as Manuel suggested for an approach, I would probably defer to the Query Management Query (QMQRY) variable substitution feature [Set Variables (SETVAR) of the Start QM Query (STRQMQRY)] instead of whatever that custom RUNSQL uses\does.

I don't think QMQRY would have an output as nice as the SQL.

09/27/16 15:02:54 PAGE 1
LIB FILE Statement MYCOUNT
Date
UPPENFILES CBCBILP 101/03/07 38,800
UPPENFILES CBCBILP 101/03/16 53,399
UPPENFILES CBCBILP 101/03/25 50,599

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Tuesday, September 27, 2016 3:02 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL output to Printer - anyway of marking/tagging the spoolfile with the PF name

On 27-Sep-2016 13:48 -0500, Rob Berendt wrote:

Now, if I knew the name of the date field for all the files, I could
submit this to batch, substituting the 3 variables:

Library
File
Date

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

Run it across an entire library.

If which date field can be determined from a list of all the date fields in the [record format of the] file, or if there is only ever one date field for the [record format of the] file, then there are numerous ways to obtain the column name(s) to enable making that substitution.
Although just as Manuel suggested for an approach, I would probably defer to the Query Management Query (QMQRY) variable substitution feature [Set Variables (SETVAR) of the Start QM Query (STRQMQRY)] instead of whatever that custom RUNSQL uses\does.

--
Regards, Chuck

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.