IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

File Aid Batch


IBM Mainframe Forums -> IBM Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
subhadrasn

New User


Joined: 01 Mar 2022
Posts: 6
Location: India

PostPosted: Mon Jan 30, 2023 2:51 pm
Reply with quote

Hi All,

Is it possible to subtract constant value from a variable that, we receive dynamically thru parm in jcl/or using fileaid batch.

To explain clearly, I need to generate a week report. So i get the current date from OPC Scheduler. But the challenge is my vsam file date field is in 9's compliment of julian date. that is 9999999-yyyyddd.
Can this be done in jcl or file-aid batch.

Thank you
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1205
Location: Bamberg, Germany

PostPosted: Mon Jan 30, 2023 3:33 pm
Reply with quote

FILEAID is not an IBM utility. Show something of your input and what you wanna see as desired output.
Back to top
View user's profile Send private message
subhadrasn

New User


Joined: 01 Mar 2022
Posts: 6
Location: India

PostPosted: Mon Jan 30, 2023 4:53 pm
Reply with quote

For example - todays julian date in YYYYDDD format is 2023030.
So my 9's compliment for todays julian date will be 9999999-2023030 = 7976969.
I will key in this date to my vsam file to fetch data.
Please note that - i have more than 10 vsam files as input for different regions.

This report needs to be run on weekly basis, so i have to fetch all the records from vsam file for current date - 7 days.

So now i need to get the current date and do this conversion and fetch the data from all the vsam files.

Hope I have made it clear. Please help with your suggestions.
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1205
Location: Bamberg, Germany

PostPosted: Mon Jan 30, 2023 5:50 pm
Reply with quote

Why not using some SORT utility for the date extraction maneuver?
Back to top
View user's profile Send private message
subhadrasn

New User


Joined: 01 Mar 2022
Posts: 6
Location: India

PostPosted: Mon Jan 30, 2023 6:12 pm
Reply with quote

Can you please guide me how can i get date with 9's complement thru JCL sort. Dynamically Subtracting from 9999999 thru sort.

Thank you in advance.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1992
Location: USA

PostPosted: Mon Jan 30, 2023 6:20 pm
Reply with quote

subhadrasn wrote:
Can you please guide me how can i get date with 9's complement thru JCL sort. Dynamically Subtracting from 9999999 thru sort.

Thank you in advance.


1) SORT is not JCL, in any manner

2) Why not to read/search some initial information about the suggested tool,???

3) FYI: The "Dynamically Subtracting" in SORT is performed via operation code SUB.
Back to top
View user's profile Send private message
subhadrasn

New User


Joined: 01 Mar 2022
Posts: 6
Location: India

PostPosted: Mon Jan 30, 2023 6:36 pm
Reply with quote

Thank you for your reply, will definitely do check
Back to top
View user's profile Send private message
dneufarth

Active User


Joined: 27 Apr 2005
Posts: 418
Location: Inside the SPEW (Southwest Ohio, USA)

PostPosted: Mon Jan 30, 2023 10:08 pm
Reply with quote

Curiosity question - How do you handle run/rerun outside of the actual current date? This may be important in constructing your solution.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IBM Tools

 


Similar Topics
Topic Forum Replies
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
No new posts How to get a stack trace on a looping... ABENDS & Debugging 5
No new posts Calling Java method from batch COBOL ... COBOL Programming 5
Search our Forums:

Back to Top