Re: Heading dates on query reports

["Mike Naughton" <mnaughton@xxxxxxxxxxxx>]

It sounds as if using the job date failed because you are running two
different jobs, and the second job picks up its own (correct) later date,
since it fires up after midnight. How about having one job start and run
(as opposed to submit) the first query), then wait for 60 minutes (or
check the time, or whatever) and run the second query. I haven't tested
this, but I would expect the job date would remain constant as the date
the original job started.

just a thought. . . .

RPG400-L@midrange.com writes:
>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.
>
>Venu, at LifeCare.


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.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
+---