Answer Posted / narasimharao
there are three types
1.cursor stability
2.rerepeatable read
3.uncommited read or dirty read
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What do you mean by storage group (stogroup)?
What is the physical storage length of timestamp data type?
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 r the comman abends in db2, jcl and cobol???????
Mention the downsides of page level lock.
What is db2 catalog database?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is cursor in dbms?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is dbrm in db2 database?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What type of database is db2?
What is db2 stogroup?
What is the role of union all and union
What is a bind in db2?