Replies to This Discussion

Permalink Reply by Srinivas Adupa on May 28, 2018 at 9:21

Hey Yehuda,

First of all, comparing all the object structure is not an easy task and requires huge set of sql's and not a single one. 

You can prepare your own DML to compare parts of structure (but definitely not the whole) with any small set of sql's. 

• ▶ Reply

Permalink Reply by Yehuda shmuel on May 28, 2018 at 9:54

Thanks Srinivas,

Is there any ready utility or DLL that output the comparison result for a certain object like, table, view ,stored procedure …?  

For example db2look utility generates a DDL for a certain database for deployment but its not suggest comparison function 

• ▶ Reply

Permalink Reply by Eswar Prasad C on June 12, 2018 at 13:59

Dont think there is any utility for such a robust comparison. There are tools like IBM object comparison tool, BMC change manager, RC migrate etc to perform this compare and give u the modified DDL's

Regards

Eswar

• ▶ Reply