Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
sort card to eliminate duplicate

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
Author Message
Purnendu.it

New User


Joined: 11 May 2007
Posts: 40
Location: chennai

PostPosted: Tue Jul 22, 2008 2:52 pm    Post subject: sort card to eliminate duplicate
Reply with quote

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
View user's profile Send private message
References
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 3542
Location: Brussels once more ...

PostPosted: Tue Jul 22, 2008 3:01 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 4607
Location: San Jose, CA

PostPosted: Tue Jul 22, 2008 9:53 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1