How can you compare table column after update and before
update?
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
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.
How to take backup of table in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is release/acquire in bind?
Which command is used to remove all rows from a table?
What is null indicator in cobol db2?
What is consistency token in db2?
What does sqlcabc has?
How to create backup table in db2?
How do you find the maximum value in a column in db2?
Name the lockable units in DB2?
How can record locking be achieved in those DB2 versions which do not support it?
How to get the ddl of a table in db2?
What is package in db2 mainframe?
What is runstats and reorg in db2?