Interested to Buy Any Domain ? << Click Here >> for more details...
How to create delta file using JCL
- 1 Answers
- 3616 Views
- CTC, I also Faced
- E-Mail Answers
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 |
Explain about LMFREE�free data set from its association with data ID
Suppose I have 5 dataset listed under a single DD name in a catlogued PROC. How can I override one of those 5 dataset (say 3rd dataset)?
what is the job entry system used in your project?
what sort card you will use to copy the data from one dataset to another dataset?
How can a stopped job be started again?
What is the function of dd disp parameter?
If a field is declared as a comp-3 field and if we want to sort a dataset based on this field, then how will the sort card be??? e.g- if we want to sort by a field which is defined as a PIC X(5) then we will mention - sort fields=(1,5,ch,a). Likewise if a field is defined as PIC S9(10)COMP-3 then in this case how will the sort field be defined (because in this case a sign is also involved)???
What 3 guidelines do we have to follow when concatenating DD statements?
What is the meaning of data definition name (ddname) and dataset name (dsname) in the DD statement?
i have 10steps and i want run step3 and based on step3 i want execute step7,8,9,10?in jcl
i) Difference between ps, esds, ii) Difference between lrecl, blksize among PS, PDS issues? i.e in jcl at dcb
I have 15 flat files. each record in the files have the monthly salary for 12 months with the employee number. Now I want to concatenate the 15 files such that for the employee numbers that are common the o/p file should have only one record and the salaries should be concatenated to that record. How can we do it with JCL?
COBOL 
