IBM Mainframe Forum

Hi all,
I´m having trouble achieving the complete output that i need.

The thing is, i need to receive two files, F1 and F2, and produce 3 output files.
The first file should contain the records that only are present in F1.
The second file should contain the records that only are present in F1.
The third file should contain the records that exist in both F1 and F2 but are differ.
The key is 01, 02, 03, ...

For example, assuming that F1 looks like this:

01 John 20
02 Rick 45
03 Anna 30

And F2 looks like this:

01 John 20
02 Rick 50
03 Frank 20

The desired output would be:

Output File 1 (only present in F1):
03 Anna 30

Output File 2 (only present in F2):
03 Frank 20

Output File 3 (updated/modified from F1 to F2 - should display what is present on F2):
02 Rick 50

Getting the first two files was simple using splice and searching here in the forum, but achieving the desired result for Output File 3 is more complicated.

Can anyone help?

Thank you,
Regards

Correction:

The second file should contain the records that only are present in F2.

It's not clear what rules or fields you want to use to get your output. For the 01 record, all three fields are the same. For the 02 record, only the first two fields are the same. For the 03 record, only the first field is the same. It's difficult to derive "rules" from that small set of examples, especially when you say "The key is 01, 02, 03, ...", but it's obvious that the other fields matter in some way as well (but how)?

Please show a better example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.

I´ll try to explain better.

The structure of the files should be seen as folow:

UserID Name Time

The two files show average login times for two different weeks.
What i want to do is put in three different files the users that logon last week but didn´t logon this week, the users that didn´t logon last week but logon this week, and the users for which any other field (except the UserID) changed. Basically, i want to put in the third file the users that had changed their name or their logon time.

As such, the output should reflect these rules:

Input files: F1 last week, F2 current week.

The first output file should contain the records that only are present in F1.
The second output file should contain the records that only are present in F2.
The third output file should contain the records that exist in both F1 and F2 but have been modified (i said that the UserID was the key, because i think you will have to make the comparison using that field).

The files shouldn´t have duplicates as the UserID is unique. The Name or Time can be duplicated of course, but depending on what you consider for key it may or may not be relevant.

The RECFM and LRECL may not be important as i will probably have to change them.
I just want to figure out how can i do this.

My first approach was to using splice and the UserID as key, see what UserIds are in F1 that aren´t in F2 and vice-versa, and write them to output files 1 and 2, but know i don´t know how to deal with the third case in which there hsa been a modification on the name or the time and therefore the record should be written to output file 3.

Thank you

Your explanation doesn't help ... in fact, it's even more confusing. Do the new fields relate to the original fields and example, or are they a different set of fields. I don't see how the Userid, Name and Time fields relate to the rules you've given about weeks.

Again:

Please show a better example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field.

I will try to example:

F1:

ID01 John 30
ID02 Susan 40
ID03 Frank 10
ID04 Mario 15


F2:

ID01 JohnT 30
ID02 Susan 40
ID03 Frank 5
ID05 Charlie 3


Now, the rules:
The first output file should contain the records that only are present in F1.
The second output file should contain the records that only are present in F2.
The third output file should contain the records that exist in both F1 and F2 but have been modified

Output1 - Only present in F1 using the UserID for comparison to answer the question - Has a user been removed?:
ID04 Mario 15

Output2 - Only present in F2 using the UserID for comparison to answer the question - Has a user been added?:
ID05 Charlie 3

Output3 - Modified records using the entire 'line' to answer the question - Has been any modification?:
ID01 JohnT 30
ID03 Frank 5

Here's a DFSORT JOINKEYS job that will do what I think you're asking for. I assumed the input files have RECFM=FB and LRECL=15, but you can change the job appropriately for other attributes. You'll need the Nov, 2009 DFSORT PTF to use JOINKEYS. If your site doesn't have that PTF installed, ask your System Programmer to install it.

Thank you for your reply.

I had already researched into joinkeys, but the site doesn't have that PTF and it shouldn't be possible to install.

Without wanting to sound ungrateful, is there any other way of doing it?

Many thanks,
Regards

You can use a DFSORT/ICETOOL job like this:

Thank you!

It doesn't seem to work very well but i will look into it further.
Meanwhile i managed to achieve the desired output using splice and making a set of comparisons.

Thank you again!
Regards