TOAD for DB2 5.0.3.718

Toad for IBM DB2
1

Hi

I have just upgraded to TOAD for DB2 5.0.3.708 . When I do a Schema Compare it
does not generate the necessary DDL for new objects . It works fine with Toad
for DB2 4.7.2.642 .

The following screens is from Toad for DB2 5.0.3.718.

This is with Toad for DB2 4.7.2.642 :

thanks

Andre
André Gagnier
Database Administrator
Tel: (613) 748-2279
Email: agagnier@cmhc-schl.gc.ca
700 Montreal Road, C3-426, Ottawa, Ontario, K1A 0P7
Canada Mortgage and Housing Corporation (CMHC)
http://www.cmhc.ca
André Gagnier
Administrateur de base de données
Téléphone : (613) 748-2279
Courriel : agagnier@cmhc-schl.gc.ca
700 chemin Montréal, C3-426, Ottawa (Ontario) K1A 0P7
Société canadienne d’hypothèques et de logement (SCHL)
http://www.schl.ca

att1.dat (38.3 KB)
att1.dat (139 KB)

2

Hi Andre,

Will you please send me the DDL for the tables and views involved?

You can send directly to me at adam.ririe@quest.com.

Regards,
Adam

3

Hi Andre,

Please disregard my request for DDL.

It looks like the difference may be due to a difference in filtering between the versions. Please give it a try with the same filters.

Thanks,
Adam
T5.0.3.png

4

Hi Andre,

Please disregard my request for DDL.

It looks like the difference may be due to a difference in filtering between the versions. Please give it a try with the same filters.

Thanks,
Adam
T4.7.2.png

5

Hi Adam

Yes it works fine . Just one click . The filter option must have changed when I
did the upgrade . I did not notice it when I did the Schema compare .

Thanks for your time.

Andre
André Gagnier
Database Administrator
Tel: (613) 748-2279
Email: agagnier@cmhc-schl.gc.ca
700 Montreal Road, C3-426, Ottawa, Ontario, K1A 0P7
Canada Mortgage and Housing Corporation (CMHC)
http://www.cmhc.ca
André Gagnier
Administrateur de base de données
Téléphone : (613) 748-2279
Courriel : agagnier@cmhc-schl.gc.ca
700 chemin Montréal, C3-426, Ottawa (Ontario) K1A 0P7
Société canadienne d’hypothèques et de logement (SCHL)
http://www.schl.ca

From:
adam.ririe_906 To:
Date:
09/03/2012 12:10 PM Subject:
[toad_db2] Re: TOAD for DB2 5.0.3.718 [2 Attachments] Sent by:
att1.dat (1.6 KB)

6

Hi Adam

Yes it works fine . Just one click . The filter option must have changed when I
did the upgrade . I did not notice it when I did the Schema compare .

Thanks for your time.

Andre
André Gagnier
Database Administrator
Tel: (613) 748-2279
Email: agagnier@cmhc-schl.gc.ca
700 Montreal Road, C3-426, Ottawa, Ontario, K1A 0P7
Canada Mortgage and Housing Corporation (CMHC)
http://www.cmhc.ca
André Gagnier
Administrateur de base de données
Téléphone : (613) 748-2279
Courriel : agagnier@cmhc-schl.gc.ca
700 chemin Montréal, C3-426, Ottawa (Ontario) K1A 0P7
Société canadienne d’hypothèques et de logement (SCHL)
http://www.schl.ca

From:
adam.ririe_906 To:
Date:
09/03/2012 12:10 PM Subject:
[toad_db2] Re: TOAD for DB2 5.0.3.718 [2 Attachments] Sent by:
att1.dat (43 Bytes)

7

Hi Adam

Yes it works fine . Just one click . The filter option must have changed when I
did the upgrade . I did not notice it when I did the Schema compare .

Thanks for your time.

Andre
André Gagnier
Database Administrator
Tel: (613) 748-2279
Email: agagnier@cmhc-schl.gc.ca
700 Montreal Road, C3-426, Ottawa, Ontario, K1A 0P7
Canada Mortgage and Housing Corporation (CMHC)
http://www.cmhc.ca
André Gagnier
Administrateur de base de données
Téléphone : (613) 748-2279
Courriel : agagnier@cmhc-schl.gc.ca
700 chemin Montréal, C3-426, Ottawa (Ontario) K1A 0P7
Société canadienne d’hypothèques et de logement (SCHL)
http://www.schl.ca

From:
adam.ririe_906 To:
Date:
09/03/2012 12:10 PM Subject:
[toad_db2] Re: TOAD for DB2 5.0.3.718 [2 Attachments] Sent by:
att1.dat (1.54 KB)

8

Hi Adam

Yes it works fine . Just one click . The filter option must have changed when I
did the upgrade . I did not notice it when I did the Schema compare .

Thanks for your time.

Andre
André Gagnier
Database Administrator
Tel: (613) 748-2279
Email: agagnier@cmhc-schl.gc.ca
700 Montreal Road, C3-426, Ottawa, Ontario, K1A 0P7
Canada Mortgage and Housing Corporation (CMHC)
http://www.cmhc.ca
André Gagnier
Administrateur de base de données
Téléphone : (613) 748-2279
Courriel : agagnier@cmhc-schl.gc.ca
700 chemin Montréal, C3-426, Ottawa (Ontario) K1A 0P7
Société canadienne d’hypothèques et de logement (SCHL)
http://www.schl.ca

From:
adam.ririe_906 To:
Date:
09/03/2012 12:10 PM Subject:
[toad_db2] Re: TOAD for DB2 5.0.3.718 [2 Attachments] Sent by:
image004.gif