Hello,

I'm looking for a DLL that will output the whole difference between two DB2 databases, do you aware of any module that applies this?

Yehuda

 

Views: 195

Reply to This

Replies to This Discussion

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. 

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 

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

One I heard about recently for LUW, in case it helps: www.raghu-on-tech.com/2017/12/19/how-to-deep-compare-two-db2-enviro..." target="_blank">https://www.google.com/amp/s/www.raghu-on-tech.com/2017/12/19/how-to-deep-compare-two-db2-enviro...

RSS

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

Creating a function in DB2

Started by Jacob Ruchotzke in What's hot ? Jun 18. 0 Replies

With the help of our IT guy i have sort of gotten an example of how to create a function in our system. Can anyone help me with this? Please see the attached SQL file.Thanks in advanceContinue

Tags: function

Conversion of BLOB to String/ Text

Started by Jitesh Audichya in Application Development and DB2. Last reply by Jitesh Audichya Apr 24. 2 Replies

Hi All,Problem Statement:I have a field with BLOB data type in DB2 database, I want to extract this blob and convert it to Text. The text data after the conversion will be in Japanese characters. How can I write a select with the conversion from…Continue

Tags: on, DB2, conversion, text, to

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service