What are the various locks available?
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 |
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
How does cobol compile db2 program?
What is the advantage in De-normalizing tables in DB2?
wht steps we need will coding cobol and db2 pgm ?
what is utility for parm lib
What is meant by dclgen?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
how will you retrieve first record in table
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
is there any restrictions for unions ?
What is the role of schema in the db2 database?