|
View previous topic :: View next topic
|
| Author |
Message |
cvadlamudi
New User
Joined: 19 Apr 2007
Posts: 68
Location: India
|
|
|
|
Hi,
Is there any option to calculate the difference between two dates.
date format will be 'CCYYMMDD'.
I have seen the option DATEDIFF using Y4T, but this is not availble in our sort. Seems this will be supported by DFSORT.
Our shop is not supporting this.
or is it possible to get the Julian date.
Thanks,
Mouli |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Post the jcl and sort control statements used, along with all of the informational output generated by the run (including the message ids). |
|
| Back to top |
|
|
cvadlamudi
New User
Joined: 19 Apr 2007
Posts: 68
Location: India
|
|
|
|
| dick scherrer wrote: |
Hello,
Post the jcl and sort control statements used, along with all of the informational output generated by the run (including the message ids). |
Please find the below details.
| Code: |
//JOBXXXXX JOB CLASS=X,MSGCLASS=X
//*
//STEP01 EXEC PGM=SORT
//SORTIN DD *
20010101 20010101
20010101 20010102
20010101 20010103
20010101 20010104
/*
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD *
INREC FIELDS=(1,8,Y4T,DATEDIFF,10,8,Y4T)
SORT FIELDS=COPY
/* |
My job abended with code 'ABENDU0016'.
The job log is below
| Code: |
SYNCSORT FOR Z/OS 1.3.2.0R U.S. PATENTS: 4210961, 5117495 (C) 2007
z/OS 1.11.0
SYNCSORT LICENSED FOR CPU SERIAL NUMBER 1D9A2, MODEL 2097 711
SYSIN :
INREC FIELDS=(1,8,Y4T,DATEDIFF,10,8,Y4T)
*
SORT FIELDS=COPY
WER901I **WARNING** SYNCSORT 1.3.2.0 WILL EXPIRE IN 39 DAYS
WER268A INREC STATEMENT : SYNTAX ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE |
|
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
the WER.... message prefix indicates that You are using SYNCSORT
topic moved to the appropriate part of the forums |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
cvadlamudi,
Difference between two input date fields is supported by the latest Syncsort MFX for z/OS 1.4 release.
You might need a sort product upgrade to be able to use this feature. |
|
| Back to top |
|
|
cvadlamudi
New User
Joined: 19 Apr 2007
Posts: 68
Location: India
|
|
|
|
| Arun Raj wrote: |
cvadlamudi,
Difference between two input date fields is supported by the latest Syncsort MFX for z/OS 1.4 release.
You might need a sort product upgrade to be able to use this feature. |
Thanks Arun |
|
| Back to top |
|
|
|
|
