Un-Answered Questions { DB2 }

What is reorg?

593


How can you find out the # of rows updated after an update statement?

613


How do you simulate the explain of an embedded sql statement in spufi/qmf?

613


What is meant by dclgen?

594


My sql statement select avg(salary) from emp yields inaccurate results. Why?

616


How is a typical db2 batch pgm executed?

622


Differentiate between cs and rr isolation levels? Where do you specify them?

553


Name the various locking levels available?

612


Explain how can you do the explain of a dynamic sql statement?

629


How do you find the maximum value in a column in db2?

626


How do you eliminate duplicate values in db2?

664


How do you concatenate the firstname and lastname from emp table to give a complete name?

581


How do you pull up a query which was previously saved in qmf?

647


When do you specify the isolation level?

588


Explain in brief how does db2 determine what lock-size to use?

571