Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?
What is the syntax of JCL statement?
how do you create a dataset in a jcl with the same file organisation as that of another existing dataset?
Where can program checkpoints be stored for use in a restart?
What is the function of dd disp parameter?
what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?
Why block size is multiple of lrecl in jcl?
what JCL Procedures?
what is the purpose of coding class parameter in job statement?
what is the difference between JES3 and JES2?
How jcl is used for testing batch programs?
How can unused space allocation be returned to the system when a dataset is closed?
What is the function of //jcllib statement?
which parameter is used to check the syntax of a jcl without executing it?
How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?
