Hi All,
I am generating a monthly report on 1st of every month. in this report I want to exclude the transactions created on 1st of month and prior day should serve as the cutoff date.
Input file date format is Julian'YYDDD'.
input to JCL:input file with julian date format on position 375 and length 5
output: Convert the above julian date to current system date and if transaction creation date = prior to current system date write to outfile1
else for transaction created on current system date write to outfile2
How to convert julian date 'YYDDD" to current system date
-
- Posts: 2
- Joined: Mon Oct 10, 2016 12:12 pm
- Skillset: Mainframes, JCL, COBOL, VSAM, DB2
- Referer: Google
-
- Global moderator
- Posts: 3025
- Joined: Sun Jul 04, 2010 12:13 am
- Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
- Referer: Google
- Location: Pushing up the daisies (almost)
Re: How to convert julian date 'YYDDD" to current system dat
JCL cannot do this. End of story.
Also, do not post in multiple forums. Choose the most appropriate and post there.
Already posted in DFSort. Locked.
Also, do not post in multiple forums. Choose the most appropriate and post there.
Already posted in DFSort. Locked.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
Regards
Nic
-
- Similar Topics
- Replies
- Views
- Last post
-
- 3
- 1518
-
by sergeyken
View the latest post
Sun Nov 29, 2020 6:47 am
-
- 1
- 5699
-
by enrico-sorichetti
View the latest post
Fri Dec 10, 2021 5:23 pm
-
-
SORT to add trailer record on change of key + Date
by Prashant_2021 » Fri Aug 27, 2021 11:04 pm » in DFSORT/ICETOOL/ICEGENER - 1
- 1684
-
by sergeyken
View the latest post
Sat Aug 28, 2021 11:15 pm
-
-
-
How to obtain only current YEAR and subtract years from it?
by prisgs » Thu Nov 17, 2022 7:13 pm » in JCL - 3
- 2460
-
by sergeyken
View the latest post
Thu Nov 17, 2022 11:24 pm
-
-
-
How to obtain only current YEAR and subtract years from it?
by prisgs » Thu Nov 17, 2022 11:27 pm » in DFSORT/ICETOOL/ICEGENER - 3
- 2014
-
by prisgs
View the latest post
Fri Nov 18, 2022 6:27 pm
-