Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by isolation level?
- 3 Answers
- 6822 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Isolation level determines how long the page or row locks
will be held.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / manidhan
ISOLATION LEVEL - Level of Isolation between two
transactions that want the same resource.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / srinivas chennareddy
Isolation level will let you know,how soon the acquired
lock will be released.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is package versioning? Please give an example.
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
Which component is responsible for processing sql statements and selecting access paths?
what is the difference between normal select query and currosor
how to execute qcmdexc in rpgle?plz write code also?
Explain what a plan is?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
What is a page?
How many Buffer pools are there in DB2 and what are they?
What is the difference between IN subselects and EXISTS subselect?
Can a Db2 table data be retrived through JCL?
Explain the use of the WHERE clause.
COBOL 
