How can you compare table column after update and before
update?
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
What's The Percentage Free Space ?
What are db2 objects?
What is consistency token in db2?
What are bind parameters in db2?
Can we update view in db2?
When do you specify the isolation level?
How will you return the number of records in table?
What is isolation level in db2?
What is meant by dclgen?
How do I add a column in db2?
What are the rules for db2 programming?
Explain about rct in db2?
is it compulsory commitment control in journal?
What is a storage group (stogroup)?
B37 abend during spufi?