What are the four lockable units for DB2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What are concurrency issues?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
What is JOIN and different types of JOIN.
Explain about cursor stability?
What is the usage of open cursor command?
how can you access index
How to resolve -504 sql code in DB2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Suppose if I need to update a column, how you do that using cursor?
What is the difference between using bind () and rebind () methods of naming class?