Interested to Buy Any Domain ? << Click Here >> for more details...
How do u achieve record level locking in DB2 versions when
record level locking is not allowed?
- 2 Answers
- 8466 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nahid gorji
By using locksize page and Isolation level CS.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / s
By storing one row per data page and using page locks.
| Is This Answer Correct ? | 1 Yes | 2 No |
How do I add a column in db2?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is a SELECT statement?
Explain about rct in db2?
What is SPUFI?
What is the physical storage length of timestamp data type?
Mention the different locking levels that are available in db2.
Is there any advantage to denormalizing DB2 tables?
What do you mean by between and in? Is between inclusive of specified range values?
What is the syntax of SELECT statement when embedded in a COBOL program?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
COBOL 
