Re: Heading dates on query reports

[rob@xxxxxxxxx]

Since you sent this to the RPG list, why not rewrite the query using RPG?
This will give you more control over which date to display.

Rob Berendt

==================
Remember the Cole!


                                                                                
                                       
                    Sean Porterfield                                            
                                       
                    <sporter@bestdist        To:     RPG400-L@midrange.com      
                                       
                    .com>                    cc:                                
                                       
                    Sent by:                 Subject:     Re: Heading dates on 
query reports                           
                    owner-rpg400-l@mi                                           
                                       
                    drange.com                                                  
                                       
                                                                                
                                       
                                                                                
                                       
                    02/14/01 10:09 AM                                           
                                       
                    Please respond to                                           
                                       
                    RPG400-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       




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