To Get Pevious Month End Date Using SYNCSORT

ballaswaroop · New User Joined: 20 Sep 2005 Posts: 25

Hi,

Is there a way to get Previous month end date?

Eg Today date is 18-June-2012. I would need to get the date as 31052012.

So, what ever is today's date - the sort card should be able to get the previous month end date.

Thanks,Swaroop

Pandora-Box · Posted: Mon Jun 18, 2012 8:46 pm

Hi,

Given the date Convert it into Yyyymmdd format
Use DATE1
Generate the control card dynamically as DATE1 - DD
You would get previous months end date

Untested

dbzTHEdinosauer · Posted: Mon Jun 18, 2012 8:55 pm

also there is a LASTDAYM function,
take LASTDAYM from (todays date - 1 month)
as Pandora said,
use the above to generate a SYSNAMES record.

LASTDAYM is described in
ftp.software.ibm.com/storage/dfsort/mvs/sortugph.pdf

subtracting months from a date is described here:
ftp.software.ibm.com/storage/dfsort/mvs/sorttrck.pdf

Skolusu · Posted: Mon Jun 18, 2012 9:46 pm

ballaswaroop,

The following DFSORT JCL will give you the desired results. I assumed your last month date needs to be at position 10.

ballaswaroop · New User Joined: 20 Sep 2005 Posts: 25

Thank you! But, looks like our vesion of SORT doesn't support Y4T. Is there any othere way to get the last date of the previous Month ?

Pandora-Box · Posted: Tue Jun 19, 2012 11:30 am

Phew Syncsort question not on DFSORT forum

enrico-sorichetti · Posted: Tue Jun 19, 2012 11:30 am

since You posted in the DFSORT/ICETOOL section of the forum
You were given a DFSORT solution.
nothing more, nothing less...

if You had posted in the right section, or told that You were using SYNCSORT
nobody would have wasted time posting a solution not suited for Your environment.

topic moved where it belongs, the JCL section

and anyway Your problem determination was wrong...
SYNCSORT does not complain about the Y4T but about DATE2-1
( unless the post was badly formatted )

Anuj Dhawan · Posted: Tue Jun 19, 2012 6:46 pm

Try this, this works with SYNCSORT FOR Z/OS 1.3.2.2R

Skolusu · Posted: Tue Jun 19, 2012 11:25 pm

Anuj Dhawan,

Couple of Questions.

1. Your sortin does NOT have any records. Does it still generate a record with an empty output?

2. What happens if the current date happens to be in January?(Jan 1st - January 31st ). The Julian date and day of the month will be the same and when you subtract them you end up with zero.

Anuj Dhawan · Posted: Fri Jun 22, 2012 7:18 pm

For both the points You're correct Kolusu. For point

1. I managed to put a comment but did not realize that input is absent. It should have been: