MAINFRAME FORUM: Remove the dups other than the lowest value

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

Remove the dups other than the lowest value

IBMMAINFRAMES.com Support Forums -> JCL

Author

Message

die7nadal

Active User

Joined: 23 Mar 2005
Posts: 154

Reply with quote

I have a file FB 2 Bytes.

Code:

A1
A2
A3
A0
B1
c1

I need to sort it in the 1st column and if there are any dups, retain only the row that has the least value in the 2nd column.

Code:

A0
B1
C1

Right now what I plan to do is Sort in ASC order column 1 and 2,

Code:

A0
A1
A2
A3
B1
C1

Then in the next Step Sort only the 1st column with SUM FIELDS=NONE,EQUALS option to get,

Code:

A0
B1
C1

Using SYNCSORT I want to know if there is a better method than this.

Send private message

References

Posted: Wed May 03, 2006 12:16 am Post subject: Re: Remove the dups other than the lowest value

DavidatK

Senior Member

Joined: 22 Nov 2005
Posts: 715
Location: Troy, Michigan USA

Posted: Wed May 03, 2006 1:45 am Post subject: Re: Remove the dups other than the lowest value

I think you got it. Dave

Send private message

jasorn

Active User

Joined: 12 Jul 2006
Posts: 109

Reply with quote

DavidatK wrote:

I think you got it.

Dave

That's the only way I know.

Send private message

sril.krishy

Active User

Joined: 30 Jul 2005
Posts: 161
Location: hyderabad

Posted: Fri Jul 14, 2006 12:08 am Post subject: Re: Remove the dups other than the lowest value

Hi, You can use the SELECT clause with FIRST option.This is the other way only. Thank you Krishy

Send private message

Display posts from previous:

IBMMAINFRAMES.com Support Forums -> JCL

All times are GMT + 6 Hours

Page 1 of 1