RE: [SYSTEM21] Selecting a calculated date within a logical file.

["Brunk, Kevin" <KBrunk@xxxxxxxxxxxx>]

Jonathan,

There is a way to do it, but it will still involve having to run a program at 
least once a day.  You can do it through a Joined view.  I've shown the DDS 
below of a test of this idea I did (and it worked)...and I've learned something 
new!

 Columns . . . :    1  71           Browse                       KBRUNK/QDDSSRC 
 SEU==>                                                                TESTJOIN 
 FMT LF .....A..........T.Name++++++.Len++TDpB......Functions++++++++++++++++++ 
        *************** Beginning of data ************************************* 
0001.00      A          R TESTJOIN                  JFILE(VRULOG TODAYFILE)     
0002.00      A          J                           JOIN(VRULOG TODAYFILE)      
0003.00      A                                      JFLD(CDATVR TODAYDATE)      
0004.00      A            CONOVR                    JREF(1)                     
0005.00      A            OPERVR                    JREF(1)                     
0006.00      A            CDATVR                    JREF(1)                     
0007.00      A            CTIMVR                    JREF(1)                     
0008.00      A            CTLNVR                    JREF(1)                     
0009.00      A            ACTNVR                    JREF(1)                     
0010.00      A            CTYPVR                    JREF(1)                     
0011.00      A            MNUIVR                    JREF(1)                     
0012.00      A            CUSNVR                    JREF(1)                     
0013.00      A            CZIPVR                    JREF(1)                     
0013.01      A            ACTTVR                    JREF(1)                     
0013.02      A            FAXNVR                    JREF(1)                     
0013.03      A            INVNVR                    JREF(1)     

The idea is to create a file that contains one record with one field, a date 
field, which in my example is named "TODAYFILE" and whose date field is called 
"TODAYDATE".  Each time the date field in TODAYDATE is updated, the view (in 
this case named TESTJOIN) will reflect only VRULOG records whose date (CDATVR 
in this example) is equal to TODAYDATE. 

If you want the date field to change automatically in TODAYFILE, you'll have to 
write a little program to update that record every day, say right after 
midnight.

Alternatively, you could use SQL and avoid having a permanent view altogether.

I will warn you, if you use product DBU to look at the results of this and you 
use F21 to list the records on the display, you will not always get reliable 
results.  I WAS able to use OPs Nav to see the data in the table reliably.

==Kevin

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]On Behalf Of Jonathan Wadey
Sent: Thursday, July 15, 2004 7:08 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Selecting a calculated date within a logical file.


Dear All,

Is it possible, and if so does anybody know how, to do a file selection on a 
date field within a logical file.

What I am trying to achieve is to set-up a logical that will only pick-up the 
previous days transactions.

TIA

Jon





Jon_Wadey@xxxxxxxxxxxxxxx
 


**********************************************************************
CONFIDENTIALITY NOTICE:  The information transmitted in this message is 
intended only for the person or entity to which it is addressed and may contain 
confidential and/or privileged material.  Any review, retransmission, 
dissemination or other use of this information by persons or entities other 
than the intended recipient is prohibited.  If you received this in error, 
please contact the sender and destroy all copies of this document.  Thank you.  
The Butler Company
**********************************************************************