how to move duplicate records to output file

sudhakarreddy.ibm · New User Joined: 20 Apr 2009 Posts: 15 Location: chennai

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

expat · Posted: Wed Jun 10, 2009 2:48 pm

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 ?

sudhakarreddy.ibm · New User Joined: 20 Apr 2009 Posts: 15 Location: chennai

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..

expat · Posted: Wed Jun 10, 2009 5:03 pm

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.