In this SPLICE example, the input records from data sets FILE1 and FILE2 are separated into the following
output data sets:
? BOTH: records that appear in FILE1 and FILE2
? F1ONLY: records that only appear in FILE1
? F2ONLY: records that only appear in FILE2
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
krish,
Would you please point to the complete Smart DFSORT Trick you're regurgitating instead of just posting part of it. In this case, it's the "Create files with matching and non-matching records" Smart DFSORT Trick at:
My English is not good.
If I explain myself badly you have patience.
If I am too much insistent,it is because I never do not succeed to explain to me well.
in short I have 2 files that they contain records that they arrive from vsam with a sort therefore to key parity.
I must obtain all the records that they have been modified, in accidental way inside of all the rows.
infinitely thanks who has helped me to write and you that you have much patience
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
My system does not support "inrec overlay"
Which sort product are you using? If you don't know, look at the messages you received in //SYSOUT - are they ICExxxs messages (DFSORT) or WERxxxs messages (Syncsort) or CASxxxs messages (CA-SORT)?
Unfortunately, due to your problems with English, we are not able to understand what you're trying to do, making it difficult for us to help you.
In your first post, you showed an example of the records in in1, in2 and out, but you only showed one record for in1 and in2, and it wasn't clear what you did to get out. Can you show a better example of the records in in1 and in2 (more records) and what you want in out, and explain the "rules" for getting from input to output?
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
Hello miosne,
Please post a few records from in1 and in2 and what you want for output if those few records were the entire input for a run. If you need to "match" records from the 2 datasets, please mention what position the "match key" begins in and how long it is. Also, what is the lrecl of each the files? Are they FB or VB or ?
This
Quote:
in1=333285
in2=333255
out=333255 or 333285
this is what I'll wanna do
333285-
333255
______
30
is unclear to me.
If you show how it relates to your input, it will help. Once the requirement is understood, better suggestions will be posted.
The position of the key is 1,9.
The lrecl is 450 FB.
The part to verify begins to the position 10.
Here some examples of the two files:
IN1
<---key--><----------data------------>
000000001simone
000000002antonio miraglia
000000003monti
000000004roberto rossi
000000005norberto marzagalli
000000006cristiano castelli
OUT
<---key--><----------data------------>
000000001simone
000000003monti
000000005norberto marzagalli
000000006cristiano castelli
Comparison the first one with the second and I must obtain the variations to key parity (key 000000001 and 000000003)
moreover the eventual ones in more present in the first one (key 000000005 and 000000006)
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
miosne,
Kriprems is on the right track, but you don't need to create three output data sets given that you only need one. Here's a modified DFSORT/ICETOOL job that will create just the one data set you want:
I do not want to adapt your job to mine.
I ask excuse.
I have only wants to make in order to learn .
I will be more careful, and I will try to follow more your indications.
.jpg)
