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
