Duplicates in i/p written into the output file on SPLICE.

Naraismha Reddy · New User Joined: 23 Apr 2008 Posts: 39 Location: Hyderabad

Hi,

I have a huge file containing 250000 records(File-1) also there are duplicate a/c no in this and second file containing records 2000(File-1). I have to make sure that records present in File-1 having a match with the records present in File-2 to be written into the output file. (i.e all the matched records from file-2 are to be written)
Field on which match is to be performed is :
File-1 : Position 18 - CH
File-2 : Position 18 - CH

Here are the control cards I have used :
File -1 containing records 250000 :-
Code: CTL1
INREC OVERLAY=(35:C'11')

File -2 containing 2000 records
Code: CTL2
INREC OVERLAY=(35:C'22')

CTL3:
OUTFIL FNAMES=OUT12,INCLUDE=(35,2,CH,EQ,C'12'),BUILD=(1,34)

Here's the splice :
Code:

COPY FROM(IN1) TO(T1) USING(CTL1)
COPY FROM(IN2) TO(T1) USING(CTL2)
SPLICE FROM(T1) TO(OUT12) ON(18,17,CH) WITH(34,2) -
USING(CTL3) KEEPBASE

Now the problem is :
The output file contain matched records from File-1 & File-2. But there are no duplicate records present in the output file.

Please Help.

ssk1711 · New User Joined: 16 Jun 2008 Posts: 40 Location: bangalore

nelson.pandian · Posted: Tue Nov 11, 2008 5:27 pm

Try this one... This will write all the duplicates from file1

Naraismha Reddy · New User Joined: 23 Apr 2008 Posts: 39 Location: Hyderabad

The Output mentioned is exactly same but somehow i couldn't get the output using the same trick.

I even tried with different options in CTL3CNTl.

Aaru · Posted: Tue Nov 11, 2008 6:12 pm

Narasimha,

Naraismha Reddy · New User Joined: 23 Apr 2008 Posts: 39 Location: Hyderabad

I didnot get any error message but i got the output without any duplicates

like
----+----1----+----2----+----3----
AAAAAAAAAA AAAAA 11111111
BBBBBBBBBB BBBBB 22222222
CCCCCCCCCC CCCCC 33333333
EEEEEEEEEE EEEEE 55555555

Naraismha Reddy · New User Joined: 23 Apr 2008 Posts: 39 Location: Hyderabad

i am using Z/OS DFSORT V1R5

Frank Yaeger · Posted: Tue Nov 11, 2008 11:40 pm

Naraismha,

Nelson's job was missing BUILD=(1,34) on the OUTFIL statement, so I updated his post to add it. When I run his job with your input, it gives your desired output. So either "your" input is not what you showed here, or your version of Nelson's job is different than Nelson's version.

If your input is the same as you posted here, then post the complete JCL and control statements that YOU used.

dick scherrer · Posted: Wed Nov 12, 2008 10:37 am

Hello,

Please re-post your info using copy/paste and the "Code" tag. Many of the people who provide answers here are not permitted to download atachments. Once the material is copied/pasted into the reply editor, use the "Code" tag for readability/alignment. Use Preview to see how your post will appear to the forum rather than how it appears in the reply editor.

When you are satisfied with the how the post looks, Submit.

Screenshots should also not be used - they are deleted.

nelson.pandian · Posted: Wed Nov 12, 2008 10:41 am

Naraismha

Can you show me, how you need the output to be present in the output file, for the input which you have uploaded.

Naraismha Reddy · New User Joined: 23 Apr 2008 Posts: 39 Location: Hyderabad

I hope this would give the picture of what is required

nelson.pandian · Posted: Wed Nov 12, 2008 11:01 am

Change ur TOOLIN statement like this and try it. It should work.

Naraismha Reddy · New User Joined: 23 Apr 2008 Posts: 39 Location: Hyderabad

Thanks Nelson this worked for me.

it was a good leason.

Got the required output

dick scherrer · Posted: Wed Nov 12, 2008 11:27 am

Good to hear it is working - thank you for letting us know

Hopefully, the "code" tag has become your ally. . .

d

Naraismha Reddy · New User Joined: 23 Apr 2008 Posts: 39 Location: Hyderabad

using the same input in the similar way can we get write the unmatched items to another output file

like the output file should be

nelson.pandian · Posted: Wed Nov 12, 2008 11:55 am

Use this Control card. You will get the unmatched records in the output file2

Naraismha Reddy · New User Joined: 23 Apr 2008 Posts: 39 Location: Hyderabad

Thanks Nelson even this worked fine

nelson.pandian · Posted: Wed Nov 12, 2008 1:02 pm

Naraismha Reddy · New User Joined: 23 Apr 2008 Posts: 39 Location: Hyderabad

Hi All,

With the current output we got can we write the count of dulicates at the end (adding one more column for the count)

The output required :
out12

Skolusu · Posted: Thu Nov 13, 2008 1:04 am

Naraismha Reddy,

Did you want to show spaces if there is only 1 record per key in OUT12? Also you have 5 records for key 0000010313 in file 1 and yet you show only 4 as duplicate count. So the first key record is not considered as dup? If that is true then Change your CTL3CNTL control cards to the following which will give you the desired results.

Naraismha Reddy · New User Joined: 23 Apr 2008 Posts: 39 Location: Hyderabad

Hi Kolusu,

Thanks for the perfect control card.
It worked fine.

i have got the required output

Out12