I definitly have to spend some time on this to get a better understanding what I can achieve with that stuff... Thx for your feedback,,,,
-----Ursprüngliche Nachricht----- Von: IBM Mainframe Discussion List [mailto:[email protected]] Im Auftrag von Elardus Engelbrecht Gesendet: Dienstag, 28. August 2012 19:03 An: [email protected] Betreff: Re: Exclude SMF Records by date&time with DFSORT Uwe Oswald wrote: >has somebody ever tried to exclude (!) SMF records from a dataset with DFSORT? >My interest is especially to exclude several (more than one) date and time >ranges. Has someone an example for me, please? Not sure which date field you're using for subsetting your data, but I have some production sample using ICETOOL for display while editing the fields: TITLE('SMF TYPE-?? RECORDS') DATE(4MD/) - HEADER('DATE') ON(11,4,DT1,E'9999/99/99') - HEADER('TIME') ON(7,4,TM4,E'99:99:99.99') - ... etc ... Basically you use DT1 and TM4 to extract and compare your date/time for later subsetting. This leads me to something like a COPY with these INCLUDE statements: INCLUDE COND=(11,4,DT1,GE,Z'19800101',AND, 11,4,DT1,GE,Z'20121231') Above is from memory/manual and is UNTESTED. [1] I don't have EXCLUDE sample at this moment... HTH! Look at http://www-01.ibm.com/support/docview.wss?uid=isg3T7000093 Groete / Greetings Elardus Engelbrecht [1] - From DFSORT Application Programming Guide: I get this tidbits: DT1 - 4 bytes - SMF date interpreted as Z'yyyymmdd' TM4 - 4 bytes - SMF time interpreted as Z'hhmmssxx' ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
