How to create delta file using JCL
Answer / sarath
I need to create delta file(only changed records in 2nd file needs to be in delta file) for a daily feed please let me know how to do it. even if there is a single character change in new file the new record should replace the old one. consider first 5 characters as a key parameter
example:
file-1
12345 abc dat1
12346 def dat2
12347 5ab ddd4
file-2
12345 abc dat1 --> same in both so no need of this record
12346 bbb dat2 --> minor changes in file-2 so it should be in output
13345 2gh dat3 --> record not at all present so this will be added to o/p
output:
12346 bbb dat2
13345 2gh dat3
| Is This Answer Correct ? | 0 Yes | 0 No |
can u execute a proc from another proc?
What are the common keyword parameters in both job and exec statements
Is it possible to define dd statements as you want?
Which is the most widely used batch performance monitor for DB2?
How to override loadlib?
What is maximum length of block size?
5 Answers Cap Gemini, Kanbay, TCS,
How to pass the parameter in parm using linkage section ? (syntax)?
lines(1,cancel)??What is meant by that??Plz explain it....
CAN ANYONE TELL ME WHAT IS "JOB-CARD"
What is the exact difference between PRTY and DPRTY
List some valid operation codes in JCL
What are hierarchy levels in jcl?