I have to compare two databases (Tables and Views defintions), Both the databases have the same number of tables and views, but I have to investigate the difference in there definitions, for example SET or MULTISET TABLES.
If anyone have scripts to make this comparison, Please let me know!
This script is not tested but I think you will get the logic easily. You can customize and expand more as per your requirements. Once you get the output, you can open in excel sheet or write unix script to do comparison, according to your convenience:
If you have access on DBC then you can write SQL statement to compare text for TVM.CreateText.
You might need to join dbc.TVM with dbc.dbase to get appropriate result.
Thank you Kawish, I will try to use this, but if you paste some sample query, It would be a great help :)