How can you compare table column after update and before
update?
- 5 Answers
- 8596 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
define clustering index.
Explain about open switch business continuity software?
What is dbrm?
What is with ur in db2?
i want to maintain uniqueness on pdf without make lf??????????
What is the max length of sqlca?
What db2 400?
What is null indicator in cobol db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
what is db2 restart?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is alias in db2?
How can we read records for specific member in CL? AND rpg?
What is a db2 collection?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
