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?
When reorg is used?
What are the various isolation levels possible?
How can you do the explain of a dynamic sql statement?
Can you use max on a char column?
List some fields from sqlca?
Explain what are the various isolation levels possible?
What is the physical storage length of the data types date, time, and timestamp?
What is the use of value function?
If I have a view which is a join of two or more tables, can this view be updateable?
What is the result of open cursor statement?