Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 0 Tue Sep 26, 2017 3:35 am
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 8 Fri Sep 22, 2017 11:35 pm
No new posts it is possible output a SET value fro... Martylin JCL & VSAM 5 Fri Sep 22, 2017 7:08 am
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us