What are the Isolation levels possible ?
Answers were Sorted based on User's Feedback
Answer / rafee s
CS -- Cursor Stability.
RR -- Repeatable Read.
UR -- Uncommitted Read
RS -- Read Stability
NC -- No Commit (smiler to UR)
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / narayana reddy
CS-cursor stability
RR-repeatable read
UR-uncommited read
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / krishnan
CS-cursor stability
RR-repeatable read
UR-uncommited read
CR-Cursor Readabiliy
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / viratarya
CS -- Cursor Stability.
RR -- Repeatable Read.
UR -- Uncommitted Read
RS -- Read Stability
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveen87ginjupalli
CS-CURSOR STABILITY
RR-REPEATABLE READ
| Is This Answer Correct ? | 0 Yes | 4 No |
How to resolve -803 sql code in DB2?
How many buffer pools are available in db2?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
How to connect to db2 database from windows command line?
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
how to u check the query is executing or not ?where will u check for sqlcode ?
What is the use of db2?
What is the difference between static and dynamic SQL?
What is SPUFI?
How can you display the current date & current time ?
What is a correlated sub query?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.