Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how to move duplicate records to output file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
sudhakarreddy.ibm
Warnings : 1

New User


Joined: 20 Apr 2009
Posts: 15
Location: chennai

PostPosted: Wed Jun 10, 2009 2:25 pm    Post subject: how to move duplicate records to output file
Reply with quote

Hi,

I have the following scenario. I have given input and output files here.
Using the following input file i need to generate the output file as given below by using JCL only.

INPUT FILE

id name
1 a
1 b
2 c
3 d
3 e

OUTKPUT FILE

id name
1 a
1 b
3 d
3 e

kindly help me to solve above problem through the JCL.

Thanks in advance
sudha
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Jun 10, 2009 2:48 pm    Post subject:
Reply with quote

Sigh

What are the file attributes of the input and output files.
What are the rules for excluding data.
What program would you like to use for this as JCL byitself accomplishes zero processing. It informs the OS of what program to execute and what files are used as input / output.
Have you searched the SORT forum for ideas.
And which SORT product do you use ?
Back to top
View user's profile Send private message
sudhakarreddy.ibm
Warnings : 1

New User


Joined: 20 Apr 2009
Posts: 15
Location: chennai

PostPosted: Wed Jun 10, 2009 4:47 pm    Post subject:
Reply with quote

Hi,

Assume the input and output file attributes are same.My output file should consist all duplicate records as shown above.I tried through sort.But i could n't get result.kindly help me to come out from this probleem.


Thanks in advance ...
sudha..
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Jun 10, 2009 5:03 pm    Post subject:
Reply with quote

Please post your efforts, and also answer the questions properly as the file attributes can alter the solution of the problem. We do not ask for information for fun, but because the information is required

Duplicate of what, you have not told us what fields are keys so how can we tell what is duplicate or not.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Incorrect output when trying to add n... monica1 PL/I & Assembler 10 Fri Jan 13, 2017 5:02 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
This topic is locked: you cannot edit posts or make replies. How to move a long alphanumeric data ... lind sh COBOL Programming 8 Mon Dec 05, 2016 7:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us