Interested to Buy Any Domain ? << Click Here >> for more details...
How can you compare table column after update and before
update?
- 5 Answers
- 10096 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
What is package in db2 mainframe?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How can deadlocks be resolved?
What are iseries servers?
How many databases can be created inside an instance in db2 ?
Why do we need reorg in db2?
what is db2 restart?
How do you select a row using indexes in db2?
What is a dbrm in db2?
How to access db2 tables in mainframe?
What is a Foreign Key?
How to test SQL -911 error while developing COB-DB2 program
What r the comman abends in db2, jcl and cobol???????
What is the maximum No of rows per page?
