compare dates



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

compare dates

Postby david lover » Wed Apr 22, 2009 11:18 pm

I am writing an racf icetool inactivity report. My question is there a way to compare dates. what i like to do is print out anyone that has not logon from today - 45 days.

icetool control statement:

 //RACFCNTL DD *                                                 
  SORT FIELDS=(19,10,CH,A,5,4,CH,A)                               
  INCLUDE COND=(5,4,CH,EQ,C'0200',AND,10,4,CH,EQ,C'IFXG',AND,     
               118,10,CH,LT,C'2009-04-01')                       
  OPTION VLSHRT                                                   


output should look like:

userid            username                last access date
xabxc             joe date                  2009-03-19


Hope this make sense.

david
david lover
 
Posts: 2
Joined: Fri Dec 19, 2008 9:38 pm
Location: columbia, sc
Has thanked: 0 time
Been thanked: 0 time

Re: compare dates

Postby Frank Yaeger » Thu Apr 23, 2009 2:10 am

You can compare to today - 45 days using the following DFSORT condition:

  ...
  118,10,CH,LT,DATE1(-)-45)   
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post