I have a file of record length 592 . I have a date field in yyyy-mm-dd format . Now, i should get records only of current date.
I have written jcl code
SORT FIELDS=COPY
INCLUDE COND=(583,7,ZD,EQ,DATE1P)
This is working only for format yyyymmdd but my requirement is to get records of current date which has format yyyy-mm-dd
can anyone please help me ?
Fetch records using JCL based on current date (yyyy-mm-dd)
-
- Posts: 3
- Joined: Mon Nov 21, 2016 8:05 pm
- Skillset: Mainframes beginner
- Referer: google first search
-
- Global moderator
- Posts: 3805
- Joined: Tue Jan 25, 2011 12:02 am
- Skillset: Easytrieve Plus, Cobol, Utilities, that sort of stuff
- Referer: Google
Re: Fetch records using JCL based on current date (yyyy-mm-
What happens when your step runs after midnight? Or you want to do a re-run? Or for testing of any type?
Good systems have a "calendar file(e)" which have all the dates you need. Does your system have one?
Good systems have a "calendar file(e)" which have all the dates you need. Does your system have one?
-
- Global moderator
- Posts: 3720
- Joined: Sat Dec 19, 2009 8:32 pm
- Skillset: Systems programming, SAS, COBOL, CICS, JCL, SMS, VSAM, etc.
- Referer: other forum
- Location: Dubuque, Iowa, USA
Re: Fetch records using JCL based on current date (yyyy-mm-
Please note that this is NOT "jcl code" (sic). You have written SORT control records which are used by an invocation of SORT within your JCL. JCL starts with // or /* (as stated in the JCL Reference manual talking about what JCL is -- see table 1).I have written jcl code
SORT FIELDS=COPY
INCLUDE COND=(583,7,ZD,EQ,DATE1P)
-
- Similar Topics
- Replies
- Views
- Last post
-
-
SORT the records based on the second word
by seethahexa » Wed Aug 19, 2020 1:30 pm » in DFSORT/ICETOOL/ICEGENER - 1
- 1404
-
by sergeyken
View the latest post
Wed Aug 19, 2020 6:08 pm
-
-
-
Create multiple records based on one record within a file.
by chillmo » Thu Aug 11, 2022 3:54 am » in Syncsort/Synctool - 5
- 7688
-
by sergeyken
View the latest post
Fri Aug 12, 2022 2:23 am
-
-
- 4
- 1664
-
by Robert Sample
View the latest post
Sat Aug 29, 2020 12:58 am
-
-
How to obtain only current YEAR and subtract years from it?
by prisgs » Thu Nov 17, 2022 7:13 pm » in JCL - 3
- 2435
-
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
- 1978
-
by prisgs
View the latest post
Fri Nov 18, 2022 6:27 pm
-