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 |
how do u send return code from cobol to jcl ?
wht do u mean by inrec and outrec ?
//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 /*
i need some shortcuts and tso commands can any on ehelp me in these ?
How can a fb file convert to vb file using sort program?
What is the use of IEBGENER ?
what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?
how can we override data definitions in jcl. can any one give detailed example
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
How much is memory space involved, when we code BLOCKSIZE,TRK & CYL ?
can any one plzzzzzz tell the jcl code for creating ps using idcams
How to find the number of duplicates in a file using Sort?