IBM Mainframe Forum

Excuse skolusu, forget my last comment.

I finally need the records with 'A', 'B' and 'M' because after I have to update information at database. But, i don't understand why I have been cases where I obtain two record (one with a 'B' and the other with an 'M') diferent with the same key and the last 4 position different. When the key is the same and the last 4 position are diferent only must be write one only record with a 'M'.

Input file (after day)

xxxx027444740052
xxxx027444870443
xxxx027444900116
xxxx027445130443
xxxx027445260003
xxxx027445550091
xxxx027445710148
xxxx027446100443
xxxx027446230026
xxxx027446490054
xxxx027446520154
xxxx027447750443
xxxx027448270154
xxxx027448690037
xxxx027448720443
xxxx027448980037
xxxx027449080443

input file (before day)

xxxx027444160020
xxxx027444740052
xxxx027444870443
xxxx027444900116
xxxx027445130443
xxxx027445260003
xxxx027445550091
xxxx027445710148
xxxx027446100443
xxxx027446230026
xxxx027446490054
xxxx027446520052
xxxx027447750443
xxxx027448270154
xxxx027448690037
xxxx027448720443
xxxx027448980037

output
......
xxxx027446520052B
xxxx027446520154M
......

Do you know why happen? I need know it because If I do delete of record at database and after I want update database with the next record, I have a problem because the record not exist.

Thank you very much and excuse for my last comment

pulcinella,

I finally need the records with 'A', 'B' and 'M' because after I have to update information at database. But, i don't understand why I have been cases where I obtain two record (one with a 'B' and the other with an 'M') diferent with the same key and the last 4 position different. When the key is the same and the last 4 position are diferent only must be write one only record with a 'M'.

*sigh* If only you had copied my control cards as is that would NEVER happen. Pay attention to the control cards I posted especially the SECTIONS statement where I am picking only 1 key based on the key.

You always show input which NEVER ever matches the rules or the output. I have no idea as to why the 027444160020 is not included in output and why 027444740052 is included in output when it is exists both files with the same exact key and ID. 027449080443 is completely missing from output.

I can't keep working on "n" different scenarios with you unless you come up with correct requirement. This will be my last post on this topic because I simply give up. Sorry

Just for your info this is what I get with your latest input

Skolosu,

I can understand you're tired but, I've re-run and I get the same result. I keep coming in sometimes two records. I have reviewed your example but I have not found error. I'm sure I copied the same. Can be the size of files?
Anyway, do not worry. Will review where the error Thanks for your time and sorry for the inconvenience