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

how can we merge two input files from two different jobs into one output file ? Please ans any one ASAP?

1 Answers  


can we bowse or edit the GDG dataset if it is a tape entry?

4 Answers  


We are using 2 files , file one has data, file two is empty.Using jcl how can we find the other file is empty?

9 Answers   CSC, IBM,


Explain about LMFREE�free data set from its association with data ID

0 Answers  


1.How to check for the errors using TYPRUN=SCAN?What will be the output if we give TYPRUN=SCAN?

11 Answers  


We are aware of eliminating the duplicate records from outyput fiel using sort utility. Can we get the duplicate records in to another file in the Same sort utility?

2 Answers  


What does a disposition of (NEW,CATLG,KEEP) mean?

1 Answers   Cap Gemini,


My requirement is : How to populate a empty PS/flat file with ONLY spaces in the first line. You should not use any input dataset to do this. I'm not sure whether you may use any utility for this purpose?

2 Answers   HCL,


when does a dataset go uncataloged?

0 Answers   IBM,


i have a jcl containing header body and trailer .in header i have viswa body 2 6 1 9 7 trailer reddy .now i need to sort only body in either asecending or descending order how can i do it

1 Answers   L&T,


Can I share my data with other jobs? How?

0 Answers  


How to release a JOB (from the input queue) held by TYPRUN = HOLD ? and how to see the installation default time after which a JOB will be automatically released ? How to see the list of currently HELD JOBS ?

5 Answers   IBM,


Categories