Interested to Buy Any Domain ? << Click Here >> for more details...
What are the various locks available?
- 5 Answers
- 12126 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lakshmisudha
locks are 2 types
1.explicet locks
cs,rr,ur,rs
2.implicet locks
shared,exclusive,update
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nag(igate)
They are the 3 types of locks
1.Mode:share,exclusive,update intent
2.Size:tablespace,table,page,row
3.Duration: Acquire,release
| Is This Answer Correct ? | 1 Yes | 1 No |
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What is db2 purescale?
What is a DBRM, PLAN ?
What is an access path?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
What is the difference between cursor and select statement?
When the like statement is used?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is sqlca?
COBOL 
