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 |
What's The Percentage Free Space ?
What is the syntax for creating a table in the db2 database?
What is a db2 table?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
What is buffrpool? Where we use it ?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
How can we read records for specific member in CL? AND rpg?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What is dbrm?
What is bind package and plan in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is data manager?