Answer Posted / sudha
share,exclusive and update
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Mention the various locks that are available in db2.
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is reorg and runstats in db2?
What is the clustering index in the db2 database?
What is null indicator in cobol db2?
How do you eliminate duplicate values in db2?
Are views updateable?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is dbrm? What it contains? When it will be created?
What is the role of the data page in the db2 database?
What is the usage of open cursor command?
What are foreign keys in db2?
What is a Foreign Key?
Why do we need reorg in db2?
What parameters are used to control the free space in DB2?