Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Difference between two dates

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
cvadlamudi

New User


Joined: 19 Apr 2007
Posts: 68
Location: India

PostPosted: Tue Jul 26, 2011 5:55 am    Post subject: Difference between two dates
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jul 26, 2011 6:43 am    Post subject:
Reply with quote

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
View user's profile Send private message
cvadlamudi

New User


Joined: 19 Apr 2007
Posts: 68
Location: India

PostPosted: Tue Jul 26, 2011 1:32 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10275
Location: italy

PostPosted: Tue Jul 26, 2011 1:33 pm    Post subject: Reply to: Difference between two dates
Reply with quote

the WER.... message prefix indicates that You are using SYNCSORT
topic moved to the appropriate part of the forums
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2284
Location: @my desk

PostPosted: Tue Jul 26, 2011 4:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
cvadlamudi

New User


Joined: 19 Apr 2007
Posts: 68
Location: India

PostPosted: Tue Jul 26, 2011 6:11 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm
No new posts Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm
No new posts Difference space showed for TS and it... autobox DB2 1 Thu Apr 14, 2016 1:07 pm
No new posts Difference Between CICS WebSupport an... sachinji84 CICS 1 Mon Mar 07, 2016 7:25 pm
No new posts Difference between -180 and -181 with... deepak_shrivastava DB2 4 Wed Jan 06, 2016 10:00 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us