RE: Heading dates on query reports

["Cindy Hudson" <cindy_hudson@xxxxxxxxxxx>]

Re:query heading dates.
Yes you are correct, query only uses the sysval QDATE. I've tried putting a
jobd with a job date specified there, then using JOBD on the submit job and
it still doesn't work. One could suggest also Query Management which allows
the importing of the specified report layout, and then using QM to load the
date into the headings.

-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of Sean Porterfield
Sent: Wednesday, February 14, 2001 7:10 AM
To: RPG400-L@midrange.com
Subject: Re: Heading dates on query reports

Joe Montes wrote:
>
> Hello to all,
>
> Does anyone know if a solution exists for the following situation.
> I want to run a query during the night and retain the date prior to
midnight
> (and the date changing).  For example, on 01/31/2001 at 11:30pm a batch
job
> query "TEST1" executes. The date on the headings is 01/31/2001.  Next, on
> 02/01/2001 at 12:30am a batch job query "TEST1" executes. The date on the
> headings must remain 01/31/2001.  I have tried using the job date but no
> luck.  I appreciate any assistance.

Some people have suggested the job date is important here, but the help
text says that &DATE in QUERY/400 is the system date.  I suspect the
date will match the system date regardless of any job date.

Using some tricks in SQL instead of QUERY/400 would be my only answer.
Store the date at the beginning of the program then add it to the header
in the SQL as a parameter.
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---