I've not had much experience at writing DFSORT SYSIN cmds beyond the real basic cmds, so I was wondering if someone could provide some assistance.
I'm trying to extract certain records from the VSI data returned from a BVIR request against a VTS cluster in a IBM GRID.
The input dset is LRECL=640,RECFM=FB.
Here are 2 sample records:
Code:
H10001,0,2011-04-29-12.05.40.954341,-1,-1,-1,0,Y,94,N,133,N,N,N,N,N,N,N,N,I,D,N,N,N,N,N,N,W,....... (don't care about the rest)
H10084,0,2011-11-19-08.52.14.532215,-1,-1,-1,0,N,110,N,130,N,N,N,N,N,N,N,N,I,D,D,N,N,N,N,N,N,......
* The 1st 5 records in the dset are header or info records and can be skipped.
What I'm after are just those records that have either either W or M in field %28 (the last field shown in the examples above).
to help people willing to answer understand better the data
it would be thoughtful to enclose the data within the code tags in order to preserve the alignment
( Your post was edited for it )
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Barry,
The number of % fields you say you want is 12, but your output shows 13 fields. Assuming you do want the 12 fields you listed, you can use a DFSORT job like the following. If you want 13 fields, change appropriately.