What are the levels of isolation available with DB2V4
Answers were Sorted based on User's Feedback
Answer / nag(igate)
CS Cursor Stability
RS Read Stability
RR Repeatable Read
UR Uncomitted Read
NC no commit-similar to UR
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / s
CS Cursor Stability
RS Read Stability
RR Repeatable Read
UR Uncomitted Read
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
What is a clustered index?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What does an outer join do?
What is deadlock?
How can you split a table in to exactly half?
What is the command used by TSO users to invoke DB2?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
What are the prerogatives?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.