2017-12-01 19:35:01 UTC
I am trying to use DFSORT to work with a variable length file.
I want to first filter on the right 'type' of record (it has SMF records in it and I'm interested in just SMF type 30 records) and then sort/sum up records based on various fields.
I am not quite sure what the 'right' way to do this is - in particular, how to filter the 'short' records out first before I sort on the SMF type 30 records? If I just try to SORT right away, DFSORT is unhappy because some of the records are shorter than the offset into the record that the field is at (offset 325). I played with the VLSHRT option but it still seemed unhappy.
Should I be running the file through some other utility first to filter out the non-SMF type 30 records or should I do this filtering first in DFSORT?
As a DFSORT newbie - the manual is a bit overwhelming so if someone has a good tutorial on this type of scenario, which I would think must not be uncommon, please point me to that.