Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Want to eliminate duplicates from the source dataset

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
reddy307
Currently Banned

New User


Joined: 09 Jun 2006
Posts: 18

PostPosted: Fri May 04, 2007 1:07 pm    Post subject: Want to eliminate duplicates from the source dataset
Reply with quote

Hi All,

I want to eliminate duplicates from dataset but i dont want to keep one record from duplicate records

for example

INPUT DATASET

11111111
11111111
11111111
22222222
22222222
22222222
33333333

AFTER ELIMINATION i want output like

11111111
22222222
33333333


How can we do it by using ICETOOL.

Thanks in advance

Reddy
Back to top
View user's profile Send private message

agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

PostPosted: Fri May 04, 2007 1:11 pm    Post subject:
Reply with quote

Have you searched before asking this on forum?
If not search on keywords 'SUM FIELDS=NONE'
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Fri May 04, 2007 1:11 pm    Post subject:
Reply with quote

Topic discussed many times in DFSORT forum. Search there.
Back to top
View user's profile Send private message
reddy307
Currently Banned

New User


Joined: 09 Jun 2006
Posts: 18

PostPosted: Fri May 04, 2007 1:44 pm    Post subject: Repost: Moved to Offtopics: how to eliminate duplicates
Reply with quote

Hi All,
I want to eliminate duplicate recoreds from dataset (ps file). But i want one occurence of duplicate records. please see the following example


I want to do it by using ICETOOL
INPUT FILE

111111111
111111111
222222222
222222222
222222222
333333333


output file

111111111
222222222
333333333

thanks in advance

Warning: Repost: http://ibmmainframes.com/viewtopic.php?p=77544
Back to top
View user's profile Send private message
GlobalGyan

New User


Joined: 31 Jan 2006
Posts: 28

PostPosted: Fri May 04, 2007 2:09 pm    Post subject:
Reply with quote

http://ibmmainframes.com/viewtopic.php?t=20493

-GG
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

PostPosted: Fri May 04, 2007 2:18 pm    Post subject:
Reply with quote

Reddy,
Your topic was moved to FAQ forum. You should post your question only once. See the link below to track your previous post.
http://www.ibmmainframes.com/viewtopic.php?t=2059
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts How to Extract BMS Marco Source from ... Howard Hinman CICS 5 Tue Oct 31, 2017 11:13 pm
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us