MVSFORUMS.com

nagarajan.dharani · Beginner Joined: 04 Apr 2007 Posts: 20 Topics: 4

Hi,

Can anyone help me one in the following requirement.

I've a fixed length record file with a employee number as one of the fields.

I need to do a sort and remove the duplicate records if the employee number occurs more than 2 times in the input file.

Is this possible through DFSORT?

For example

INPUT FILE:

88888
88888
77777
88888
77777
66666

My output should be
77777
77777
66666

The employee 88888 had occurred 3 times so the number should be removed.

Thanks,
Dharani

Nic Clouston · Posted: Mon Jan 14, 2008 4:58 am Post subject:

do you want it sorted decending or ascending? What is your record length? what position is your employee number? and what data format?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

Arunprasad.K · Posted: Mon Jan 14, 2008 9:39 am Post subject:

Dharani,

You can refer the post in the below link and modify to have an IF condition in the FileAid step. Or you can change the DFSORT accordingly

http://www.mvsforums.com/helpboards/viewtopic.php?t=2174&highlight=total+splice

Arun.

kolusu · Posted: Mon Jan 14, 2008 11:15 am Post subject:

nagarajan.dharani,

The following DFSORT/ICETOOL JCL will give you the desired results.

ranga_subham · Intermediate Joined: 31 Jan 2006 Posts: 255 Topics: 72

this is really helpful.....

Can we know more about the Lower(3) option?

Thanks.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

ranga_subham · Intermediate Joined: 31 Jan 2006 Posts: 255 Topics: 72

Thanks vkphani.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard

Frank Yaeger · Posted: Tue Jan 29, 2008 11:01 am Post subject:

ranga_subham · Intermediate Joined: 31 Jan 2006 Posts: 255 Topics: 72

Thanks Frank.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard