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
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:
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
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: 19254 Location: Inside the Matrix
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 ?
out=333255 or 333285
this is what I'll wanna do
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:
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)