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?
How would you find out the total number of rows in a db2 table?
Can you tell me how can you find out the # of rows updated after an update statement?
What are the contents of dclgen?
Why select is not preferred in embedded sql programs?
How do you select a row using indexes in db2?