Un-Answered Questions { DB2 }

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

574


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

604


What are the contents of dclgen?

652


Why select is not preferred in embedded sql programs?

709


How do you select a row using indexes in db2?

641


When reorg is used?

668


What are the various isolation levels possible?

643


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

633


Can you use max on a char column?

636


List some fields from sqlca?

607


Explain what are the various isolation levels possible?

606


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

602


What is the use of value function?

622


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

688


What is the result of open cursor statement?

634