Un-Answered Questions { DB2 }

How would you find out the total number of rows in a db2 table?

579


Can you tell me how can you find out the # of rows updated after an update statement?

612


What are the contents of dclgen?

661


Why select is not preferred in embedded sql programs?

715


How do you select a row using indexes in db2?

647


When reorg is used?

678


What are the various isolation levels possible?

649


How can you do the explain of a dynamic sql statement?

637


Can you use max on a char column?

638


List some fields from sqlca?

613


Explain what are the various isolation levels possible?

610


What is the physical storage length of the data types date, time, and timestamp?

612


What is the use of value function?

629


If I have a view which is a join of two or more tables, can this view be updateable?

694


What is the result of open cursor statement?

638