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 to delete generations of gdg without deleting gdg base?

3 Answers  


What is the use of DUMMY statement in the JCL? What is the use of DUMMY Utility in the JCL?

12 Answers   Convergys,


Name the system library from which modules are retrieved at execution

2 Answers  


What parameters can be used to limit the number of records written to a sysout dataset?

1 Answers  


What is SORT ? How do we eliminate duplicate records ? How do I select some records using SORT ?

9 Answers   GE, Xansa,


What is the function of job statement in jcl?

0 Answers  


How do you restart a PROC from a particular step?

5 Answers  


what is force complete

2 Answers   IBM,


I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK

0 Answers   IBM,


what is fixed length and variable length and difference between them

1 Answers   CGI, Wipro,


Can we Execute a job without specifying Job Name in the Job Card?

2 Answers  


While using SORT FILES =NONE,XSUM I am getting error "ICE172A E XSUM IS NOT SUPPORTED - USE ICETOOL SELECT IF APPROPRIATE"..I want to write duplicate records a a serparte file..how i can do tht?

3 Answers   Steria,


Categories