What is reorg?
How can you find out the # of rows updated after an update statement?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is meant by dclgen?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How is a typical db2 batch pgm executed?
Differentiate between cs and rr isolation levels? Where do you specify them?
Name the various locking levels available?
Explain how can you do the explain of a dynamic sql statement?
How do you find the maximum value in a column in db2?
How do you eliminate duplicate values in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How do you pull up a query which was previously saved in qmf?
When do you specify the isolation level?
Explain in brief how does db2 determine what lock-size to use?