Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Process file after 7 days of hold

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
charlessxavier

New User


Joined: 12 Sep 2010
Posts: 4
Location: India

PostPosted: Tue May 22, 2018 3:54 pm    Post subject: Process file after 7 days of hold
Reply with quote

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.
Back to top
View user's profile Send private message

sergeyken

Active User


Joined: 29 Apr 2008
Posts: 474
Location: Maryland

PostPosted: Fri May 25, 2018 5:49 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Fri May 25, 2018 11:28 pm    Post subject:
Reply with quote

Quote:
what would happen if the batch is cancelled on any day and the GDG isnt created
What is the expectation in this scenario?
Back to top
View user's profile Send private message
dneufarth

Active User


Joined: 27 Apr 2005
Posts: 290
Location: Cincinnati OH USA

PostPosted: Sat May 26, 2018 12:59 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 981
Location: Richmond, Virginia

PostPosted: Sat May 26, 2018 9:21 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need to write the date at the end of ... Poha Eater DFSORT/ICETOOL 2 Tue Jul 23, 2019 2:33 pm
No new posts Access file which has DSNTYPE=LIBRARY maxsubrat JCL & VSAM 11 Fri Jun 21, 2019 4:09 pm
No new posts Mainframe to linux file count mismatch shreya19 All Other Mainframe Topics 4 Thu Jun 13, 2019 9:49 pm
No new posts Copy physical Tape files to a Mainfra... Dadi Krishna Teja JCL & VSAM 11 Thu May 16, 2019 10:25 pm
No new posts How can I close a flat file in Ezytrieve dibyendumandal11111 CA Products 3 Wed Apr 17, 2019 2:19 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us