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

I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK

0 Answers   IBM,


What will happen when we try to pass data from JCL to COBOL using PARM parameter without declaring the length field in Linkage Section?

2 Answers   IBM,


What is a MODEL Paramater in GDG ?

2 Answers   Xansa,


Whats error code s222?

7 Answers   Patni,


how can i use the parameters decalred in main pgm in sub pgm

2 Answers   TCS,






What dd statement is used to supply the name of a dataset?

0 Answers  


describe the dd statement,its meaning,syntax and keywords?

1 Answers  


In order to continue a job after a return code of 12 in step1, what the step2 exec statement include?

1 Answers  


I have a JCL with 100 steps. I want run the Alternate steps in the JCL ( Like 2 ,4,6,8 etc.. ). How can I acheive this scenario? If It is by Cond Parameter can you provide the Condition code for that?

5 Answers   Polaris, Tech Mahindra, UST, Wipro,


what is check pending option

1 Answers   Fujitsu,


How to remove the spaces at end of each record in the output file Via COBOL program? note: The file has a VB length ----TRY

0 Answers  


Can we create VSAM file by using IEBGENER?

4 Answers   Principal Finance,


Categories