Paired changes and Non paired chnges in seperate files

ajithkumarsl · New User Joined: 23 Oct 2006 Posts: 19 Location: Chennai

Hi,

Going through some similar cases, I cannot find a exact solution for my requirement.

I did a Superc comparison and i got a result like this

4166 TOTAL CHANGES (PAIRED+NON PAIRED CHNG)
2940 PAIRED CHANGES (REFM+PAIRED INS/DEL)
1215 NON-PAIRED INSERTS
11 NON-PAIRED DELETES

Now, My requirement is I want

1. 2940 paired changes in one file
2. 1215 non paired inserts in another one file
3. 11 non-paired deleted in another one file

I am quite new to the mainframes.

I tried with the Splice option in ICETOOL, but I am getting an output as Paired and non-paired inserts(2940 + 1215) records in one file and Paired and Non-paired deletes(2940 + 11)records in another file and I cannot separate the paired change and non-paired change records.

I tried with Comparex also but getting a similar result.

Is there any option in Superc itself for getting these in separate files?

Please help me out to solve this issue.

Thank you,
Ajith Kumar

krisprems · Posted: Tue Jun 19, 2007 9:49 am

ajithkumarsl

murmohk1 · Posted: Tue Jun 19, 2007 10:35 am

krisprems,

ajithkumarsl · New User Joined: 23 Oct 2006 Posts: 19 Location: Chennai

Thanks for ur reply Kris.

The result will be in the spool or in a data set and this will look like as follows -

1. for Non-paired Inserts

I - 53171310048692D5359600041105
I - 53171310048692W1071200041105
I - 53171310048692W5287700041105
I - 53171310048692W5327400041105

2. for non-paired deletes

D - 29300727406532W5325500095022
D - 29300727406532W5863500095022
D - 29300727406532W6040600095022

3. for Paired chnages

I - 29300727574019W10706000081267
D - 29300727574019W10706000081267
I - 29300727574019W10879000081267
D - 29300727574019W10879000081267
I - 29300727574019W53255000081267
D - 29300727574019W53255000081267

These all will be mixed up and it is even difficult to seperate a few records manually. I have thousands of records and i need any other way.

I want the output files like

In one file only the inserts:

53171310048692D5359600041105
53171310048692W1071200041105
53171310048692W5287700041105
53171310048692W5327400041105

In another file only the deletes:

29300727406532W5325500095022
29300727406532W5863500095022
29300727406532W6040600095022

In another one file only the paired changes

29300727574019W10706000081267
29300727574019W10706000082267
29300727574019W10879000084267
29300727574019W10879001081167
29300727574019W53255400082567
29300727574019W53255000087867

By using splice option in the ICETOOL I tried to seperate by using the following control statement -

SPLICE FROM(DS01)) TO(DS02) ON(1,29,CH) -
WITH(33,1) KEEPNODUPS

The DS01 and DS02 are two DD names. The 32 and 33rd position I sufixed with a Tag say '11' and '22' in the old and new files respectively which I used for Superc Comparison. The DS01 will contain all the merged records from the Old and New files sufixed with 11 and 22 respectively. The output DD(DS02) will be contain(after run) the records with sufix 11, 22 and 12. the 11 will be the in new file but not in old file(non-paired inserts) and 22 will be the in old file but not in new file(non-paired deletes) and 12 will be the common records.

But now what is happening is the Icetool considers the paired changes also Non-paired inserts or deletes.

I think i explained what i did clearly.

can u say any other option or utility to do the required action Please?

Thanks for ur time.

krisprems · Posted: Tue Jun 19, 2007 1:12 pm

ajithkumarsl

Check this ICETOOL solution for extracting

ajithkumarsl · New User Joined: 23 Oct 2006 Posts: 19 Location: Chennai

Hi Kris,

U are right. In this case this is a solution.

But in a couple of other instances, I found that the paired changes, the records are matching only to a certain extend - i mean it will not be the exact duplicate.

For example please make a look on the following records

I - 29300727574019W10706000081267
D - 29300727574019W10706000082267
I - 29300727574019W10879000084267
D - 29300727574019W10879001081167
I - 29300727574019W53255400082567
D - 29300727574019W53255000087867

I did the comparison with 1:29 positions.

The report was like

3 TOTAL CHANGES (PAIRED+NONPAIRED CHNG)
3 PAIRED CHANGES (REFM+PAIRED INS/DEL)
0 NON-PAIRED INSERTS
0 NON-PAIRED DELETES

if I try by ur method, we will not get any record in any of the file(out,out1 and out2).

Can u please try this.

Thank you for ur time.

krisprems · Posted: Wed Jun 20, 2007 1:31 pm

ajithkumarsl

ajithkumarsl · New User Joined: 23 Oct 2006 Posts: 19 Location: Chennai

Hai Kris,

I am sending the full report. I think this will clear your doubt.

LINE COMPARE SUMMARY AND STATISTICS

0 NUMBER OF LINE MATCHES --- 3 TOTAL CHANGES (PAIRED+NONPAIRED CHNG)
0 REFORMATTED LINES --- 3 PAIRED CHANGES (REFM+PAIRED INS/DEL)
3 NEW FILE LINE INSERTIONS --- 0 NON-PAIRED INSERTS
3 OLD FILE LINE DELETIONS --- 0 NON-PAIRED DELETES
3 NEW FILE LINES PROCESSED
3 OLD FILE LINES PROCESSED

LISTING-TYPE = DELTA COMPARE-COLUMNS = 1:29 LONGEST-LINE = 30
PROCESS OPTIONS USED: NONE

(the hypens are not in the report - i put for understand the spaces between that)

I think it is a little bit tough to identify a common characterestic in the paired change.

Thank you very much for helping me Kris

krisprems · Posted: Thu Jun 21, 2007 11:01 am

ajithkumarsl

ajithkumarsl · New User Joined: 23 Oct 2006 Posts: 19 Location: Chennai

Hi Kris,

That is absolutely currect Kris.
This only a sample. there are thousands of records and for all these records it is very difficult to find a comon characteristics like this.

For example please look in this report form superc

I - 29140727574019W107060000000100
D - 29130727574019W107060000000100
I - 29315727574019W108790000000200
D - 29314727574019W108790000000200
I - 29301627574019W532554000000300
D - 29301527574019W532550000000300

0 NUMBER OF LINE MATCHES---- 3 TOTAL CHANGES (PAIRED+NONPAIRED CHNG)
0 REFORMATTED LINES ---- 3 PAIRED CHANGES (REFM+PAIRED INS/DEL) 3 NEW FILE LINE INSERTIONS ---- 0 NON-PAIRED INSERTS
3 OLD FILE LINE DELETIONS ----- 0 NON-PAIRED DELETES
3 NEW FILE LINES PROCESSED
3 OLD FILE LINES PROCESSED

LISTING-TYPE = DELTA COMPARE-COLUMNS = 1:29 LONGEST-LINE = 30

These cases are very complicated. Very difficult to find a common characteristic by which we can extract.

Kris, is there any option in Superc It self for extracting this?

Thank you very much for ur time Kris.