Sir, You are an absolute legend. Thank you 3000.
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Tuesday, April 21, 2020 9:08 PM, Sri h Kolusu <[email protected]> wrote: > Kekron, > > > I'm looking to get 1 record for each type-subtype combination. > > That is, 1 rec of 30_1, 1 of 30_2, and so on. > > AFAIK SMF records which have a subtype are > 2,30,32,33,41,42,70-79,84,86,88,89,92,94,96,97,98,106,108 and 113 . If you > have any other record type that have a subtypes then you can add them as a > symbol and also add them to INCLUDE cond. > > Most of the records have the subtype at position 23 except for record type > 84, The subtype for record type 84 is at position 25. So you just need > an INREC statement to build that record type differently. > > So you can use the following DFSORT JCL to get the desired results. A > brief explanation of the job. > > STEP0100 - Deletes the output file it existed. > STEP0200 - Extracts 1 sub-type record for each record that has a subtype. > STEP0300 - Verification step that creates 2 reports. Record type count and > another Record type + Sub type Count > > You can just run the first 2 steps. the 3rd step is optional > > (See attached file: SMFEXT.txt) > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > IBM Mainframe Discussion List [email protected] wrote on > 04/20/2020 09:32:36 PM: > > > From: kekronbekron [email protected] > > To: [email protected] > > Date: 04/20/2020 09:33 PM > > Subject: [EXTERNAL] Re: Print/copy one record of each type/subtype > > Sent by: IBM Mainframe Discussion List [email protected] > > Hi Kolusu, > > We are all forever grateful for your DFSORT help, thank you :) > > I'm looking to get 1 record for each type-subtype combination. > > That is, 1 rec of 30_1, 1 of 30_2, and so on. > > A bit disappointed that I can read VB/VBS with RECFM=U in the DD, in > > a JCL (in order to read BDW/RDW), but that throws the whole concept > > of 'logical record'. > > So ... just wondering if there's a way to get sample records with > > BDW/RDW. > > > ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ > > On Monday, April 20, 2020 11:16 PM, Sri h Kolusu [email protected] > > wrote: > > > > Kekron, > > > Are you looking for a summary of subtypes for every smf record? I wrote > > an > > > > ICETOOL job for Cheryl Watson's newsletter under "User Experiences and > > > Tips" which lists the count how many records it found of each type and > > > subtype and produce a little report saying something like: > > > TYPE SUBTYPE COUNT > > > 30 1 18446 > > > 30 2 2788 > > > 30 3 49083 > > > 30 4 49326 > > > 30 5 19162 > > > 30 6 210 > > > 41 3 41 > > > ... > > > or > > > Do you need to write out the first record for each subtype? Let me know > > the > > > > requiement and I will show you a way to get it done using DFSORT. > > > Thanks, > > > Kolusu > > > DFSORT Development > > > IBM Corporation > > > > 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 > > -- > > 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
