How to create delta file using JCL



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

Post New Answer

More JCL Interview Questions

how to execute the last 5 steps in jcl

2 Answers   Syntel,


Max generations in GDG??

15 Answers   Xansa,


Differentiate between addressing mode and run mode.

1 Answers  


What is the meaning of the following declaration : DCB=BLKSIZE=, What is the difference between above declaration & not specifying DCB at all for a output file?

1 Answers  


Which dd parameters are required?

1 Answers  


How do you access a file that had a disposition of KEEP?

3 Answers  


Can comments be specified at the very beginning of a jobcard? Will the JCL execute?

3 Answers  


Differentiate between the joblib and the steplib statements?

1 Answers  


Name the system library from which modules are retrieved at execution

3 Answers  


In sms datasets, what is the function of the dd avgrec keyword?

1 Answers  


How can we execute only one step in a job

22 Answers   MAHINDRA, Mind Tree, Tech Mahindra,


Why we will create load module in PDS only, Why nt in PS?

2 Answers   TCS,


Categories