Please accept this dual purpose response (both to John and to Ben). Yes, the include clause can be coded as GT,GE,LT,LE; however, for some, as yet, unknown reason, that construct continued to include older records. The present construct only includes the desired records, but is SQL like in its ponderousness. Thanks to both of you for the assist; I guess I was hoping for some kind of special register ala SQL as in GE (CURRENT DATE - 365 DAYS).
"Chase, John" <[EMAIL PROTECTED]> wrote: > -----Original Message----- > From: IBM Mainframe Discussion List On Behalf Of Ed Long > > Hi all. > I'm trying to develop a simple purge using DFSORT that drops > all records in the input older than 1 year. The target field > is an externalized DB2 timestamp. > So far, the following works, sort of, but is not very > elegant. Any suggestions? > > SORT FIELDS=(COPY) > > INCLUDE COND=(21,7,CH,EQ,C'2004-07',OR, > > ... > > 21,7,CH,EQ,C'2005-07') How about INCLUDE COND=(21,7,CH,GE,C'2004-07') or OMIT COND=(21,7,CH,LT,C'2004-07') ? -jc- ---------------------------------------------------------------------- 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 Edward Long ---------------------------------------------------------------------- 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
