Process file after 7 days of hold

charlessxavier · New User Joined: 12 Sep 2010 Posts: 4 Location: India

We have received a requirement from business wherein a set of records should be held in current day's batch and should be processed after 7 days of hold.

We tried sorting the records to a GDG and then use -5th version for referring the file, but in this method we are suspecting what would happen if the batch is cancelled on any day and the GDG isnt created.

As the records have current date in them, we also tried sysdate minus 7 and check the same, but we require the 7 days difference only for business days excluding weekend.

So, i would like to get some other ideas from you on this.

Thanks in advance.

sergeyken · Posted: Fri May 25, 2018 5:49 am

What kind of tool is used? COBOL? REXX? SORT? ASSEMBLER? ETC?

When comparing to SYSDATE also use WEEKDAY calculation to modify your offset between (SYSDATE-7), (SYSDATE-8), and (SYSDATE-9)

The most of modern tools include various date calculation functions.

Arun Raj · Posted: Fri May 25, 2018 11:28 pm

dneufarth · Posted: Sat May 26, 2018 12:59 am

Does it have to be GDG?

Can the accumulation be in KSDS or DB2?

Extraction/deletion of records can be done programmatically in conjunction with a calendar dataset/table.

As mentioned earlier, not getting records or even getting them twice must be considered based upon how records are batched.

Phrzby Phil · Posted: Sat May 26, 2018 9:21 am

If you have spent any time at all reading previous posts on this forum you must know that you are talking about generations, not versions.