How can you compare table column after update and before
update?
Answer Posted / harsha
Based on the situation, one can use Union/Inner Join.
| Is This Answer Correct ? | 0 Yes | 9 No |
Post New Answer View All Answers
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is load replace in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is the information associated with sysibm.syslinks table?
What is plan in cobol db2?
What is db2 bind process?
What is the role of data manager in the db2 database?
What is db2? Explain.
What is bufferpool in db2?
What is the maximum No of rows per page?
Why select is not preferred in embedded sql programs?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is null in db2?
What is null value in db2?