Un-Answered Questions { DB2 }

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

570


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

602


What are the contents of dclgen?

642


Why select is not preferred in embedded sql programs?

700


How do you select a row using indexes in db2?

633


When reorg is used?

663


What are the various isolation levels possible?

637


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

628


Can you use max on a char column?

631


List some fields from sqlca?

602


Explain what are the various isolation levels possible?

602


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

593


What is the use of value function?

612


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

683


What is the result of open cursor statement?

627