Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DFSORT - Ice tool Help - Duplicates.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
rajantsr

New User


Joined: 31 Jan 2007
Posts: 21
Location: Chennai

PostPosted: Sun Mar 09, 2008 4:38 pm    Post subject: DFSORT - Ice tool Help - Duplicates.
Reply with quote

Hi Frank ..

Here are the inputs
Code:

File 1
-------
F1  F2
100 B
100 C
200 E
400 H


Code:

File 2
--------
F1  F2F3       F4
100 A 1/1/2008 10
100 A 2/1/2008 20
100 A 3/1/2008 30
100 A 4/1/2008 40
100 A 5/1/2008 50
100 A 6/1/2008 60
200 D 1/1/2008 20
200 D 2/1/2008 40
200 D 3/1/2008 60
200 D 4/1/2008 80
200 D 5/1/2008 100
200 D 6/1/2008 120
300 F 1/1/2009 30
300 F 1/1/2008 60
300 F 2/1/2008 90
300 F 3/1/2008 120
300 F 4/1/2008 150
300 F 5/1/2008 180
300 F 6/1/2008 210


Code:

Desired output
-----------------
F1  F2F3       F4
100 A 1/1/2008 10
100 A 2/1/2008 20
100 A 3/1/2008 30
100 A 4/1/2008 40
100 A 5/1/2008 50
100 A 6/1/2008 60
100 B 1/1/2008 10
100 B 2/1/2008 20
100 B 3/1/2008 30
100 B 4/1/2008 40
100 B 5/1/2008 50
100 B 6/1/2008 60
100 C 1/1/2008 10
100 C 2/1/2008 20
100 C 3/1/2008 30
100 C 4/1/2008 40
100 C 5/1/2008 50
100 C 6/1/2008 60
200 D 1/1/2008 20
200 D 2/1/2008 40
200 D 3/1/2008 60
200 D 4/1/2008 80
200 D 5/1/2008 100
200 D 6/1/2008 120
200 E 1/1/2008 20
200 E 2/1/2008 40
200 E 3/1/2008 60
200 E 4/1/2008 80
200 E 5/1/2008 100
200 E 6/1/2008 120
300 F 1/1/2008 60
300 F 2/1/2008 90
300 F 3/1/2008 120
300 F 4/1/2008 150
300 F 5/1/2008 180
300 F 6/1/2008 210


All files are flat files.

Is it possible to get a solution using Icetool for this.

Please help me out. Thanks for your help.
Back to top
View user's profile Send private message

rajantsr

New User


Joined: 31 Jan 2007
Posts: 21
Location: Chennai

PostPosted: Sun Mar 09, 2008 4:43 pm    Post subject:
Reply with quote

All the files are FB 80.
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Sun Mar 09, 2008 5:21 pm    Post subject: Reply to: DFSORT - Ice tool Help - Duplicates.
Reply with quote

Rajan,

Post few more details of your requirement.
Back to top
View user's profile Send private message
rajantsr

New User


Joined: 31 Jan 2007
Posts: 21
Location: Chennai

PostPosted: Mon Mar 10, 2008 12:07 am    Post subject: Reply to: DFSORT - Ice tool Help - Duplicates.
Reply with quote

Details:

1) Both input files are flat file FB 80
2) Output file is also FB 80
3) Input file 1 and Input file 2 keys will be first 3 bytes(which is File1.F1 and File2.F1).
4) Both files will have duplicates in it.
5) For every record in file 1
For every match File1.F1 = File2.F1
Write a output record with File1.F1 File1.F2 File1.File2.F3 File2.F4
Next
Next
6) Write all File2 records in to output file
7) Sort the output file ascending Outfile.F1 Outfile.F2
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Mon Mar 10, 2008 9:05 pm    Post subject:
Reply with quote

rajanstr,

what is the maximum no: of duplicates you can have in each file? If the no: of duplicates are less than or equal to 10 then , check out the solution posted here

http://ibmmainframes.com/viewtopic.php?p=113849#113849
Back to top
View user's profile Send private message
rajantsr

New User


Joined: 31 Jan 2007
Posts: 21
Location: Chennai

PostPosted: Mon Mar 10, 2008 9:52 pm    Post subject:
Reply with quote

There can be any number of duplicates.. icon_sad.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Updating the counters after eliminati... PANDU1 DFSORT/ICETOOL 12 Mon Nov 21, 2016 9:47 am
No new posts How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
No new posts Interface from Mainframe to Confluenc... hblun CLIST & REXX 4 Tue Sep 20, 2016 5:47 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us