IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DFSORT - To remov set of recs when 1st rec meets criteria


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
antonrino.b

New User


Joined: 10 Jan 2006
Posts: 76
Location: Germany

PostPosted: Sat Dec 09, 2006 1:28 pm
Reply with quote

Hi,

Can I use DFSORT for this?

I have a file as below: A set of records with types A, B, C, D repeats. and A record has key field.

Code:
A   101
B   B1
C   C1
D   D1
A   102
B   B2
C   C2
D   D2
A   101
B   B3
C   C3
D   D3
A   102
B   B4
C   C4
D   D4


I need to write only those set of records whose A rec has key field as 101 into output file..
i.e. I need to write A, B, C, D records only if A record has 101 in key field.

My output for the above file should look like:

Code:
A   101
B   B1
C   C1
D   D1
A   101
B   B3
C   C3
D   D3


Is this possible with DFSORT?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Sat Dec 09, 2006 9:40 pm
Reply with quote

Yes. You can use the technique shown in the "Include or omit groups of records" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

If you need more specific help with this, tell me the RECFM and LRECL of the input file.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
No new posts DFSORT - VB file RDW getting overridden DFSORT/ICETOOL 3
Search our Forums:

Back to Top