SYNCSORT date function

anand tr · New User Joined: 12 Aug 2008 Posts: 38 Location: chennai

I have a KSDS in which one of the field is out-date.
the requirement is to delete the records which dates back to an year old.
i.e i dont want the records which are older than an year. Can we compare the current run date and out-date?

anand tr · New User Joined: 12 Aug 2008 Posts: 38 Location: chennai

moving forward, i dont want a program to be used. do we have a date function in SORT itself? which compares the two dates ??
can any1 suggest me on this?

anand tr · New User Joined: 12 Aug 2008 Posts: 38 Location: chennai

Am using syncsort and the date format is ddmmyyyy

Anuj D. · Posted: Thu Sep 04, 2008 8:05 pm Post subject:

Sarting Position of Date please.

Anuj D. · Posted: Thu Sep 04, 2008 8:18 pm Post subject:

Hello again,

It should be noted that this kind of "suicide sort" is not recommended unless you can afford to lose the VSAM file if something goes wrong. It's safer to go from the VSAM file to a temporary file and then from the temporary file back to the VSAM file.

anand tr · New User Joined: 12 Aug 2008 Posts: 38 Location: chennai

hi anuj.. thanks for the suggestion..suppose we take a copy of the KSDS in a flat file , how can we go ahead comparing the dates using a JCL itself?shud we convert the dates into days? or there is any function in SORT which just compares the dates directly .??

arcvns · Posted: Fri Sep 05, 2008 10:01 am Post subject:

Anand,

You can directly filter the VSAM file using date functions available in SYNCSORT into a flat file and REPRO the flat file back into VSAM.

Thanks,
Arun

vinay kashyap · Posted: Fri Sep 05, 2008 11:26 am Post subject:

i hope you can try this.am not sure though as am new to mainframes

you can backup the KSDS into a flat file . i hope we can use sortcopy for that.
then u can use the flat file and REPRO the same into the KSDS.
include cond(50,10,ch,le,date1(/)+365).
sort fields=copy
well how is your date format? and wat about the seperators?
if any flaw, anyone please correct me.

arcvns · Posted: Fri Sep 05, 2008 12:21 pm Post subject:

Anand,

Here's a SYNCSORT job which filters records based on current date. I have assumed VSAM input, FB,LRECL=80 and the date(ddmmyyyy) starting at pos-5.

anand tr · New User Joined: 12 Aug 2008 Posts: 38 Location: chennai

Thanks for that Arun,
i just had a doubt whether the DATE1 function would work for ddmmyyyy format. but looking at your e.g it is cleared now.