How can you quickly find out the number of rows updated
after an update statement?
Answer / vamshi
check for the value is in sqlerrd(3). it contains the no.
of rows updates.
Is This Answer Correct ? | 23 Yes | 0 No |
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
Give the name of some fields form sqlca.
Explain about dbrm.
What is sqlcode -922 ?
How do we specify index to include or not during bind process.
Explain the use of the WHERE clause.
What is the STOSPACE Utility used for?
How to define the data items to receive the fetch items for the SQL?
What is concurrency?
Where besides the DB2 catalog is database object information stored by DB2?
What if we fail to give values in columns declared as NOT NULL ?
What is the role of the data page in the db2 database?