Using Toad for DB2 v 4.7 user tried to do schema compare and got missing warning message. On Toad for DB2 v 4.0 the warning message was:
'WARNING! Can't insert data for column xxx.yyyy. There is no such column in the source table.'
Also Schema compare got different result: from Toad for DB2 v4.0 dropped 20 and created 24 indexes also dropped 7 and created 9 views. However,
Toad for DB2 v 4.7 dropped 4 and created 24 indexes also dropped 5 and created 9 views
STATUS
Waiting for a fix with CR 79500 on a future release of Toad for DB2.
WORKAROUND:
None