Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to create delta file using JCL



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

Post New Answer

More JCL Interview Questions

In a single step if input file is present then only need to copy into output file or else need to through a RC is it possible. Note : i want it in a single step

1 Answers  


Are all (i), (ii), (iii), (iv) of the below are VALID to reference a temporary dataset ? STEP2 DD1 DD DSN = &&TEMP STEP3 DD2 DD (i) DSN = TEMP (ii) DSN = *.TEMP (iii) DSN = *.STEP1.DD1 (iv) DSN = *.STEP1.DD1.ONE

8 Answers   IBM,


can we have more than one job in a single job card that is we are specifying only one 'job' statement in the jcl.

7 Answers   Accenture,


What is the difference between these two parameters? -> accounting information -> class how would it bring the differrence to a program?

4 Answers  


proc1,proc2,up to proc5 is there if i want to call proc1 and proc5how can u write the code

2 Answers  


How many types of parameters are used in JCL and what are mandatory parameters of JOB statement.

13 Answers   IBM,


What is the max blocksize for a Tape file?

2 Answers  


What will happen if we write two STOP RUN's in a COBOL program?

4 Answers   Satyam,


What is the use of symbol // in jcl?

0 Answers  


Statement1 "We can not use UNCATLG in SMS managed VSAM datasets" Statement2 "We can not delete a SMS managed data set without UNCATLG it" (P-353, Saba Zameer book) Then how do we delete SMS managed VSAM datasets ?

1 Answers   IBM,


What does a disposition of (MOD,DELETE,DELETE) mean ?

0 Answers  


what is DD statement is used in JCL?

0 Answers  


Categories