MAINFRAME FORUM: Need to Sort out the repeated values

Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD

Need to Sort out the repeated values

IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL

Author

Message

balukanna

New User

Joined: 09 Apr 2008
Posts: 8
Location: chennai

Posted: Mon May 12, 2008 5:02 pm Post subject: Need to Sort out the repeated values

hi, i need to sort out the repeated values ex: i/p 456 200 567 100 456 200 567 200 789 300 o/p 456 200 456 200

Send private message

References

Posted: Mon May 12, 2008 5:02 pm Post subject: Re: Need to Sort out the repeated values

V S Amarendra Reddy

Active User

Joined: 13 Sep 2006
Posts: 73
Location: INDIA

Reply with quote

Hi,

This DFSORT/ICETOOL job will give you the desired result.

Code:

//SORT EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD *
456 200
567 100
456 200
567 200
789 300
/*
//OUT DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(1,3,CH) ON(5,3,CH) ALLDUPS
/*

Here I assumed the the two fields are different so we have two on fields.

Regards
Amar

Send private message

balukanna

New User

Joined: 09 Apr 2008
Posts: 8
Location: chennai

Posted: Wed May 21, 2008 10:41 am Post subject:

hi Amar, sorry for the delay... thanks a lot... its working fine...

Send private message

Display posts from previous:

IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL

All times are GMT + 6 Hours

Page 1 of 1