Interested to Buy Any Domain ? << Click Here >> for more details...
How can you compare table column after update and before
update?
- 5 Answers
- 10264 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 copy a table in db2?
what is db2 restart?
How does db2 sample database connect?
List out the buffer pools in db2
Explain the function done by data manager?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What does db2 plan contain?
What is cobol db2?
What is database reorganization?
What are the contents of dclgen?
What do you mean by between and in? Is between inclusive of specified range values?
What is buffer pool in the db2 database?
How and when does the db2 enforces the unique key?
What is db2 stogroup?
What is db2 plan table?
