Interested to Buy Any Domain ? << Click Here >> for more details...
How can you compare table column after update and before
update?
- 5 Answers
- 10024 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / mahesh vasudevan
If you mean a new column has been added to an existing table
or data been updated to an existing table data. I am not
sure on this question. Let me assume that you are talking
about data. Any update that takes place will have two
records logged -one is prior to update and another is after
update and these information goes to Logs. Logs are used
while recovery process for forward and point in time recovery.
and you can make an SQL query for "Union" - "Intersection"
operation to find the differences.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How do I delete a column in db2?
What happens in bind step in a db2 program?
What is the role of the data page in the db2 database?
What is concurrency?
Before you give the explain statement, what are the prerogatives?
What is db2 optimizer?
What is db2? Explain.
Highlight all the advantages that are attached to a package.
What is cobol db2?
What is table space in db2?
Can we insert update delete in view?
What are the 2 sqlcodes that are returned?
What is a db2 collection?
How to create db2 table in mainframe?
What is commit in db2?
