On Fri, 24 Oct 2008 11:25:41 -0500, Elardus Engelbrecht <[EMAIL PROTECTED]> wrote:
>>You'll have to find a way to change the date field dynamically if you want to >>automate this job. > >Or better: > >//ULDFCNTL DD * > SORT FIELDS=(10,8,CH,A) > INCLUDE COND=(5,4,CH,EQ,C'0200',AND, > 118,10,CH,GT,DATE1(-)-90) > >This is DATE1 format YYY?MM?DD where the ? is replaced by what delimitor is >used, IRRDBU00 uses '-', so you use DATE1(-). > >The -90 is minus 90 days and is used with comparing with LT. > >So above translate to: > >Select all records where last used date is LESS than 90 days of the job run >date. > >HTH! > >Groete / Greetings >Elardus Engelbrecht Many thanks! That is exactly what I think that I need. -- John ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html