I need some help here. My Dataset is a UNLOAD (Table DB2), then I need a way to sort this file by field in date format (DD.MM.YYYY) and excluding dates less than "22.07.2008". Is there a way to use ICETOOL or SORT without INREC/OUTREC, just using OMIT or INCLUDE option?
Is there a way to use ICETOOL or SORT without INREC/OUTREC, just using OMIT or INCLUDE option?
No, because the DD.MM.YYYY format of your date cannot be collated correctly without transforming it to YYYYMMDD. If your date was in a form that could be collated correctly without transforming (such as YYYY.MM.DD) then you could use INCLUDE or OMIT directly.
However, is there another way using "DATE? format"
I assume you mean DATEn (e.g. DATE1). DATEn is used for the current date in various forms (or a date relative to the current date such as DATE1-30). Since you said you want to use a specific date of "22.07.2008", DATEn isn't relevant. If you want to use the current date, then you could use OMIT with an appropriate form of DATEn vs the transformed date.