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

Do we need to code DCB parameters when using DISP position as MOD?

1 Answers   Accenture,


Where & How Do You Code Identifier In Jcl?

0 Answers   IBM,


What is concatenating?

0 Answers  


When will we need to specify Space parameter ?

3 Answers   Wipro,


A chkpt is the parameter coded for multi-volume qsam datasets in a dd statement. When a chkpt is coded as chkpt=eov, a checkpoint is written to the dataset specified in the sysckeov statement at the end of each volume of the input/output multi-volume dataset. State whether true or false?

0 Answers   IBM,


AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE DUPLICATES HOW TO REMOVE THE DUPLICATE FILES IN JCL? CAN I GET THE PROGRAM FOR THIS

3 Answers  


i have 5 steps to execute in that i want to skip 3nd step and start execute from forth step how can u do this.

7 Answers   Syntel,


I have mainpgm(abc) this is the only cobol pgm(non-db2).And this pgm calling subpgm name "acd" this also only cobol(non- Db)and this pgm calling some other subpgm this pgm has cobol-db2 pgm. 1) IF you calling static mode how to run and how to compile? 2) IF you calling dynamic mode how to run and how to compile? plz suggestion me.

0 Answers   HP,


What does the one advantange of using IEBUPDTE?????

2 Answers  


I need exexution process for JCL programs

0 Answers  


What is Backward Referencing ?

3 Answers   HSBC,


I had Records in file Like this Company Code IBM 2 IBM 1 IBM 4 WIPRO 3 WIPRO 2 WIPRO 9 TCS 4 TCS 6 TCS 3 i want the record of every company with highest code How can i do that?

3 Answers   Wipro,


Categories