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

How to include desired records


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

New User


Joined: 29 Jan 2007
Posts: 33
Location: chennai

PostPosted: Mon Mar 16, 2009 3:41 pm
Reply with quote

Hi,

My I/p File have the below values

aaa13
bbb34
ccc28
ddd23

My O/p file should fave

bbb 3 4
ccc 2 8

That is the sort processing should check ( ( field 5 sub field 4) ) greater than field 4.. If this condition is satisfy then then record should go to o/p file..

Please help me how to do that in dfsort ???
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Mar 16, 2009 8:17 pm
Reply with quote

Hello,

When you have a question, you should start a new topic for your question rather than post a reply to some exixting topic.

You should do a much better job of explaining what you want to do. . .

You didn't name the fields. What are the lrecl and dsorg for the file?
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: Mon Mar 16, 2009 9:11 pm
Reply with quote

Quote:
That is the sort processing should check ( ( field 5 sub field 4) ) greater than field 4.. If this condition is satisfy then then record should go to o/p file.


What do you mean by "field 5 sub field 4"? Do you mean (field5 - field4)?

If so, then why would bbb 3 4 be in your output file, since 4-3 = 1 which is not greater than 4?

Why do you have blanks in your output record that don't appear in your input records?

You need to do a much better job of showing a good example of the records in your input file and what you expect for output, and explaining the "rules" for getting from input to output and how they relate to the example.
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 Compare 2 files(F1 & F2) and writ... JCL & VSAM 3
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
Search our Forums:

Back to Top