MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

DATE Sort operation Help needed !

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
dragone_007
Beginner


Joined: 18 Mar 2008
Posts: 24
Topics: 6
PostPosted: Mon May 25, 2009 5:37 am    Post subject: DATE Sort operation Help needed ! Reply with quote
Hello to everyone,

I tryed the following SORT card for selecting records wich are equivalent to TOD's date minus 7 days but didn't worked. Gives me nothing in Output. Can anyone help me out ? Thanks a lot in advance.

Code:

//SORTIN   DD *                                                         
DENIS    090505                                                         
JOHNNY   090515                                                         
DENIS    090516                                                         
JOHNNY   090520                                                         
DENIS    090525                                                         
PAOLO    090518                                                         
DENIS    090518                                                         
MIRKO    090519                                                         
DENIS    090517                                                         
//SORTOUT  DD SYSOUT=*                                                 
//SYSIN    DD *                                                         
  OPTION COPY                                                           
  INCLUDE COND=(10,6,Y2W,EQ,Y'DATE1'-7)
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
PostPosted: Mon May 25, 2009 9:56 am    Post subject: Reply with quote
dragone_007,

Y2W is of the format xxxxYY , ie the year is at the end , but looks like your data has the YY in the beginning which is Y2T format(YYxxxx )

so change your Include cond to

Code:

INCLUDE COND=(10,6,Y2T,EQ,Y'DATE1'-7)

_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
dragone_007
Beginner


Joined: 18 Mar 2008
Posts: 24
Topics: 6
PostPosted: Mon May 25, 2009 10:52 am    Post subject: Reply with quote
Thanks a lot for your prompt response kolusu, I tryed it with Y2T format and worked fine. Very helpful.

Best regards
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group