What are ISOLATION LEVELS? Where do we need to specify them?
Answer Posted / ashu
An isolation level determines how data is locked or
isolated from other processes while that data is being
accessed.It is page level locking.these can be specified in
4 ways-
1)cs(cursor stability):-
Used when concurrency is important.
2)RR(Repeatable read)
Used when Data Integrity is Important.
3)RS(Read stability)
4)UR(uncommited read)
Uncommited read or Dirty Read.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is redefines clause in COBOL?
Which mode is used to operate the sequential file?
What is the difference between binary search and sequential search?
How to get the last record in vsam file in cluster? And how can you get the kids file records into your cobol program?
how do you reference the variable unblock file formats from cobol programs
What guidelines should be followed to write a structured cobol prgm?
I have a File that has duplicate records. I need only those records that occur more than thrice.?
Whats the difference between search & search ALL?
What is perform what is varying?
input= ,,,, mainframe training ,,, hyderabad .... location.... output1=$ mainframe training in hyderabad location$ output2=**** mainframe training in hyderabad location ****. In this pgn when we give input considering the spaces the output is displayed in this format.Like in the place of ,,,, $ should be displayed likewise.So please helpmeout.
What is amode(31)
What are the different rules of SORT operation?
How are the next sentence and continue different from each other?
What kind of error is trapped by on size error option?
I have one ps file in which there are 3 fileds emp_no,emp_name and leave_app.this ps file information give the detail of employee which is going to apply for leave.suppose emp_no=113430,emp_name=ajay,leave_app=1 that means he is going to apply for 1 day leave.and accordingling the table in db2 will be updated means if he has that no of leave in his account then he will get dat leave and updated acc. in table(leave_balance=previous leave present in table-leave_app).Now i want to check whther the updated result is correct or not by comparing the two ps file using IEBCOMPARE or icetool so what is going to be the two ps file and how its is going to be compare.