How to create delta file using JCL

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Name a few IBM utility programs, and explain its function.

4440


Explain the function of //jcllib statement?

708


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.

1953


//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 /*

908


Explain dd statement in jcl?

644






How gdg are concatenated?

672


What is the significance of addrspc parameter in exec statement?

730


what happens in conversion stage in job processing?

730


How does the jcl specify the job to os?

696


Suppose I have five jobs to do. But I want to hold one?

660


Can we use DISP=SHR in output file in JCL

953


I have a job called careerride and some steps in it as step1,step2. But I want to execute step2 before step1 ? How do I do that?

831


How can values be passed from the job stream to an executable program?

875


What are the utility programs in jcl?

648


What do you understand by the term “keyword” with respect to jcl and what is the opposite of the term?

678