Interested to Buy Any Domain ? << Click Here >> for more details...
How can you compare table column after update and before
update?
- 5 Answers
- 9921 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kingmanish
Its always industry practice to take Image copy of the
table before going for inserts updates etc.
you can unload current data from the table and the data
from the image copy before update and compare the two.
thanks
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / anju
What the hell are you talking about Harsha?? Why do you want to answer if you know nothing in DB2?? Irritating mann!
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / raghu
by using db2 utilities of unload,we have to copy before upadate and after update then we should see the difference bet the to copys
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / harsha
Based on the situation, one can use Union/Inner Join.
| Is This Answer Correct ? | 0 Yes | 9 No |
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What is cascading rollback?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
How to resolve -502 sql code in DB2?
how can you access index
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the meaning of -805 SQL return code?
What is db2 look?
What is db2 bind process?
How to execute stored procedures?
What is a synonym? How is it used?
when does the SQL statement gets executed when you use cursor in the application programming ?
COBOL 
