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 |
Write a query to extract first 5 characters of a name in the column Stud_Name?
what needs to be done if a table is in copy pending / check pending status?
How to create backup table in db2?
My SQL is not performing well. Describe how will you fine tune it?
What is a DB2 catalog?
List out the three types of page locks that can be held.
How to select the duplicate rows from a table?
What are the bind parameters ibm db2?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is meant by index cardinality?