Query for an utility to copy records on condition
Posted: Tue Mar 30, 2010 12:58 am
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.
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.