Skip to Content
0
Former Member
Oct 31, 2005 at 09:33 PM

Logic for Date

15 Views

Hi,

I have a program which currently retrieves the records from a Z table based on the date

in the selection screen. This program runs everday at 11:30.

the change is that the Z table can update at any time. so, when this job is run the program

retrieves the records based on date( for ex: 10/20/2005) .

now, when the z table gets updated again at 3:30pm, that information is not being retrieved,

its like this : z table has 5 records on 10/20/2005 and program runs at 11:30 --- unix file generated

ztable has added 20 more records on 10/20/2005 at 2:00PM

now when i run the job the next day, then it should pull the prevoius day's 20 records which have

not been generated in a unix file. is it possible ?