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 |
can we maintain 2 generations with different Lengths in Same GDG ?
Explain about LMINIT - generate a data ID for a data set
When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?
In all our JOB Statement we have always COND=(4,LT) defined. Nevertheless when a Job failed the last step should then be executed (send a message to an user). Due to we don't like to change all our JOB's (ca. 2000), we are looking for a simply solution.
Hi, all suppose i have 5 steps (S1,S2,S3,S4,S5) what will happen if cond is true or false (which of the other steps get executed)? 1) //s3 exec pgm=abc,cond=(0,le) 2) //s3 exec pgm=abc,cond=(0,le,step2) 3) In the jobcord RESTART=step3,cond=(0,le) 4) can i code COND=TRUE in jobcard, if yes what will happen?
Which is the most widely used batch performance monitor for DB2?
which utility is used to run a cobol-db2 program?
Is acct parameter mandatory?
What is QSAM error usually when it is occurs?
How to submit multiple jobs. These jobs are members in PDS. The second job should run if the first job runs successfully and so on.
how are instream data terminated?
Can we able insert data into a PS file Using IEBUPDTE utility??? If Yes can anyone describe it please..