Re: Heading dates on query reports

[Sean Porterfield <sporter@xxxxxxxxxxxx>]

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
+---