How can you find out the # of rows updated after an update statement?
what is a corelated subquerry?
Give a brief description of db2 isolation levels?
Explain transactions, commits and rollbacks in DB2.
What is cascading rollback?
What is the logical entity between plan and Package?
What is the difference between TYPE 1 index & TYPE 2 index
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
What is null indicator in db2?
How to fetch the uncommited data from table ?
What is the latest version of ibm db2?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
When can an insert of a new primary key value threaten referential integrity?