var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Checksum for a table
I need to check if two tables on different databases contains the same data.
I wish to calculate a checksum at table level and if they are different calculate it at row level in order to locate the differences.
Anyone knows if there is a DB2 function to accomplish this task?
there is a tool asntdiff which is part of DB2 II(or Websphere II, whatever they call it now) ... This can be used to comapre the data in two tables ..
You can also use EXCEPT operation ... create a nickname from the remote table, call it remote_tab and if local_tab is the table you want to compare withj
select col1,col2 from local_tab
select col3,col4 from remote_tab
This will list alll rows in local_tab not in remote_tab ...
Visit the new-look
, register to gain access to the excellent content.
I've seen on the documentation for the asntdiff command syntax, but are you sure that this will work without the support tables (Q or SQL Replication)?