Want to eliminate duplicates from the source dataset

reddy307 · New User Joined: 09 Jun 2006 Posts: 18

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

agkshirsagar · Posted: Fri May 04, 2007 1:11 pm

Have you searched before asking this on forum?
If not search on keywords 'SUM FIELDS=NONE'

murmohk1 · Posted: Fri May 04, 2007 1:11 pm

Topic discussed many times in DFSORT forum. Search there.

reddy307 · New User Joined: 09 Jun 2006 Posts: 18

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: ibmmainframes.com/viewtopic.php?p=77544

GlobalGyan · New User Joined: 31 Jan 2006 Posts: 28

ibmmainframes.com/viewtopic.php?t=20493

-GG

agkshirsagar · Posted: Fri May 04, 2007 2:18 pm

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