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,     
  OPTION VLSHRT                                                   

output should look like:

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

Hope this make sense.

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


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:

Frank Yaeger - DFSORT Development Team (IBM) -
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at
User avatar
Frank Yaeger
Global moderator
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times



  • Related topics
    Last post