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 do u send return code from cobol to jcl ?

2 Answers   TCS,


wht do u mean by inrec and outrec ?

1 Answers   IBM,


//S10 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //CON DD DSN=VAR.INPUT1,DISP=SHR // DD DSN=VAR.INPUT2,DISP=SHR //OUT DD DSN=VAR.OUTPUT,DISP=(NEW,CATLG,DELETE), // SPACE=(CYL,(5,5)),UNIT=SYSDA //TOOLIN DD * * Splice the needed data from the two VB files together SPLICE FROM(CON) TO(OUT) ON(5,5,CH) WITHALL - WITH(12,5) WITH(22,20) VLENMAX /*

0 Answers  


i need some shortcuts and tso commands can any on ehelp me in these ?

1 Answers  


How can a fb file convert to vb file using sort program?

0 Answers  






What is the use of IEBGENER ?

2 Answers   Cap Gemini, Wipro,


what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?

0 Answers   IBM,


how can we override data definitions in jcl. can any one give detailed example

3 Answers   TCS,


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  


How much is memory space involved, when we code BLOCKSIZE,TRK & CYL ?

1 Answers  


can any one plzzzzzz tell the jcl code for creating ps using idcams

2 Answers   Fiserv,


How to find the number of duplicates in a file using Sort?

4 Answers   Fidelity,


Categories