How can you compare table column after update and before
update?
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 |
What is a collection?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is index cardinality?
What information is held in SYSIBM.SYSCOPY?
How is the SUBSTR keyword used in sql?
What is the role of data manager in the db2 database?
In terms of DB2 indexing, what is the root page?
What is db2 command?
What is db2 purescale?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What does the CHECK Utility do ?