How can you compare table column after update and before
update?

Answers were Sorted based on User's Feedback



How can you compare table column after update and before update?..

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

How can you compare table column after update and before update?..

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

How can you compare table column after update and before update?..

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

How can you compare table column after update and before update?..

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

How can you compare table column after update and before update?..

Answer / harsha

Based on the situation, one can use Union/Inner Join.

Is This Answer Correct ?    0 Yes 9 No

Post New Answer

More DB2 Interview Questions

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,


Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  


In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  


What is syscat in db2?

0 Answers  


Explain the contention situations caused by locks?

0 Answers  






Name some fields from SQLCA

1 Answers  


What is db2 stogroup?

0 Answers  


What is a page?

2 Answers  


Can any one tell me about Restart logic in DB2.

2 Answers  


What information is contained in a SYSCOPY entry?

2 Answers  


what is static sql? what is dynamic sql? Give me details

3 Answers  


Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  


Categories