Hi,
I have a dataset which would be having the dataset name with date qualifier like beow, where the last qualifier is the date(MMDDYY) :
ABCD.ABCDEF.ABCDEF.032410
ABCD.ABCDEF.ABCDEF.032510
ABCD.ABCDEF.ABCDEF.032310
I wanted to copy all the file name that have been created before particular date which will be read from another file to purge them through IDCAMS step.
The other data set would be having the date like below :
250310
So the new dataset which has to be created for purging by IDCAMS should be like :
DELETE ABCD.ABCDEF.ABCDEF.032310 PURGE
DELETE ABCD.ABCDEF.ABCDEF.032410 PURGE
So, can some one help me in meeting this requirement.
I hope the requirement is clear for all, if you can suggest me any other way of purging the datasets in the file is even fine.
Regards,
Nagesh D.
Query for an utility to copy records on condition
Moderators: Frank Yaeger, Moderator Group
-
- Member
- Posts: 16
- Joined: Sun Dec 27, 2009 12:37 pm
- Frank Yaeger
- Moderator
- Posts: 812
- Joined: Sat Feb 18, 2006 5:45 am
- Location: San Jose, CA
- Contact:
Is 250310 a ddmmyy date? What is the RECFM and LRECL of that file?
What is the RECFM and LRECL of the file with the dataset names? Does the mmddyy date in this file always start in position 20, or can it start in other positions. If the mmddyy date can start in different positions in different records, then what are the "rules" for finding the starting position of the date?
What is the RECFM and LRECL of the file with the dataset names? Does the mmddyy date in this file always start in position 20, or can it start in other positions. If the mmddyy date can start in different positions in different records, then what are the "rules" for finding the starting position of the date?
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
-
- Member
- Posts: 16
- Joined: Sun Dec 27, 2009 12:37 pm
Hi Frank,
Thanks for the reply and the query.
Both the data sets are of LRECL 80 only, the data mmddyy would be starting from position 1 itself in the other dataset.
So it will be like, one dataset will be having the date value in the first six chars and the other would be having the data set names starting from position 1 itself. All the dataset names will be of the same length differing only by the last date qualifier.
Let me know in case of any queries
Regards,
Nagesh D
Thanks for the reply and the query.
Both the data sets are of LRECL 80 only, the data mmddyy would be starting from position 1 itself in the other dataset.
So it will be like, one dataset will be having the date value in the first six chars and the other would be having the data set names starting from position 1 itself. All the dataset names will be of the same length differing only by the last date qualifier.
Let me know in case of any queries
Regards,
Nagesh D
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page