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 can u understand ps and pds from their names ?

1 Answers   TCS,


What is the function of dd disp parameter?

0 Answers  


How is a GDG base created?

5 Answers  


A STEP has more than 1 file as INPUT. And we have to put all these records int 1 output file. How to do ? //InputF  DD DSN=ID.File1              DSN=ID.File2              DSN=ID.File3

1 Answers   FIS,


Can you give the sort card to arrange the specific column in the version of GDG.

1 Answers  






If Region=0k means What Happen?

2 Answers   IBM,


My Question is 1. How to cound no. of records in JCL. Please explain with an example. 2. How to execute only odd steps in JCL? I know EDIT TYPE = Inculde, Step Name = 1,3,5 and COND code for all even step. Anyone knows other than this.

0 Answers  


Explain about LMCOPY -

1 Answers  


What is 'mounting' of volumes ? Is there anything that a programmer can do in it ? How to find currently mounted volume ?

0 Answers   IBM,


What is order of searching of the libraries in a JCL?

4 Answers  


What is a GDG

4 Answers   IBM,


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

3 Answers  


Categories