Joined: 14 Jul 2010 Posts: 13 Location: United States
I have a flat file with records having a date field (CCYY-MM-DD format).
The file will have data for a particular month (say September) and few records from next month (say October).
I have a monthly Job which will run on every 7th of a month and it needs to process data for the prior month.
In above scenario, on 7th October, I need to process data only for September month. Any records for October should be written to a separate file for next months processing.
Is this something I can achieve through SORT -
If the date field from the input file falls on or in between first or end date of the prior month then write to an output file
If Greater then End date of the prior month, then write off to another file.