|
View previous topic :: View next topic
|
| Author |
Message |
Purnendu.it
New User
Joined: 11 May 2007
Posts: 57
Location: chennai
|
|
|
|
Hi all,
my requirement is like that.
i need a sort jcl to eliminate duplicate from a input file and
have that duplicate records in another output file..
eample:
suppose my input file contains:
10
11
13
14
15
11
13
16
output1:
10
11
13
14
15
16
output file2:
11
13
hope i am clear.
suggestions are welcome.one more thing can i do this in a single step using
sort card |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| If you search the forum - search button above - and select the DFSORT forum and use duplicates as your keyword you will find a lot of recent examples of what you want to do. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Purnendu.it,
Here's a DFSORT/ICETOOL job that will do what you asked for:
| Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=... input file
//OUT1 DD DSN=... output file1
//OUT2 DD DSN=... output file2
//TOOLIN DD *
SELECT FROM(IN) TO(OUT1) ON(1,2,CH) FIRST DISCARD(OUT2)
/*
|
|
|
| Back to top |
|
|
|
|
