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 jcl work to handle various input output file operations?
what is SOC4 error?
When we use conditional statement in JCL using if-then-else-endif, IF statement is true, the step is bypassed or executed?
How to identify where file is empty or not? How many ways are there to identifying?
i just need the first and last record from a sequencial file?how
Suppose I have a file with three fields with data in the following format 1. empid - S9(4) COMP 2. empname - X(20) 3. empsal - S9(5)V(2) COMP-3 If I view this file, it will not be in a readable format. How to display the empid and empsal fields in a readable format without using COBOL program? What kind of SORT card will have to be coded?
What is the job entry system used in your project? based on what criteria the sequence of jobs are picked if priority is not mentioned in the job card?
Suppose there r total 10 steps. Out of which i want to execute only the 7th step. How can i do that....????
A maximum of 100 chars can be passed to Cobol through Parm in JCL, If we want to pass more than 100 Chars how we can do it ?
What is the exact difference between PRTY and DPRTY
What are the kinds of job control statements?
what is use of dsn parameter in dd statement?