Hi Mark, Working with CR59341 we were not able to duplicate the exception you described. We processed some changes to fix it. Can you please perform the same...
Hi I'm using the Beta Toad for DB2 4.5.0.602 , SCHEMA'S COMPARE component between two UDB V9.1 fixpack 5 databases . One of the tables that is being...
agagnier@...
Jun 3, 2009 6:17 pm
2860
Hi Nancy This is regarding CR 62540 . I've just tried the SCHEMA COMPARE with the Synchronization Wizard with Beta Toad for DB2 4.5.0.602 and I did not get...
agagnier@...
Jun 3, 2009 6:23 pm
2861
Thanks for the feedback Andre. Also, I am researching your other post regarding why Toad generating a LOAD when the object contained an XML column. I'll...
Hi Andre, Can you try an extended alter on this same table ...no need to run it. I just would like to know if you get the Load generated or the Import. We...
Also, Are you certain you were using Schema Compare when you received the script and not the Compare Object optio? Compare Object is accessible by selecting...
Hi Nancy It looks like the ALTER table generates an EXPORT then a LOAD . It seems to handle the Identity column correctly . Below you will find the Alter...
agagnier@...
Jun 4, 2009 12:33 pm
2865
Hi Nancy Its a Schema Compare . There is data in the target tables, hence the need to unload , recrete with new columns. thanks Andre André Gagnier Database...
agagnier@...
Jun 4, 2009 12:40 pm
2866
Hi Andre, I was able to generate the utilities using Schema Compare however, I am correctly getting the Import command generated. The Alter of the table...
Hi Nancy, I did a Quest Schema Compare . I then selected only the table in question to synchronise . It generated an export/import but it did not handle...
agagnier@...
Jun 4, 2009 5:45 pm
2868
Hi Andre, The script generated you included is definitely invalid for the reasons you stated. I used the same table that you used and I did a schema compare...
Hi all, Â Mr. Udo Brede (Senior Presales Consultant, Quest Software GmbH, Germany) asked me to post this error here, so I hope someone from Quest can help me....
Hi Nancy In my PRESERVE data options I have the same as you ( see below) . I also have no data in the source but data in the target table . I do the...
agagnier@...
Jun 5, 2009 2:38 pm
2872
Hi, It works fine with me. It might be an authority issue. Could you please run the following statement from CLP (Command Line Processor). Let me know the...
Hi, My apology for the mistake. I wanted to respond to the other mail involving migration. I couldn't create the Access violation you mentioned. It works fine...
Hi Andre, I still am unable to create either scenario exactly as you describe. For both scenarios I get the export, import and the alter table identity column...
Hi Iqbal, no problem. I actually found a fix - I completely removed all Quest Applications, then deleted all Quest- and Toad-Directories, then deleted all...
Hi Nancy Below you will find the 'Compare Schema ' script generated by the synchronize wizard . Its big , but all the info is there . Whats "weird" is...
agagnier@...
Jun 9, 2009 5:16 pm
2878
Does Toad support the PLANMGMT option of rebind, I'm not seeing any additional options in the rebind dialog. Thanks Mark....
Mark - Toad for DB2 4.5 has limited support for DB2 version 9 on z/OS, and does not currently support the use of the PLANMGMT option. I have entered CR 63,527...
Radim – This has been addressed in our latest beta (602) From: toaddb2beta@yahoogroups.com [mailto:toaddb2beta@yahoogroups.com] On Behalf Of Radim Kolar ...
I was attempting to create a nickname for a table on an Oracle server when I received this error message. There is a FOR UPDATE that is being added to the sql...
Mark - For the 4.5 release, Toad is supporting only DB2 server types when creating nicknames. We will be adding support for additional server types in the...
Hi! I have deinstalled last version of Beta and installed newest one. Now I have found out a Problem by setting default schema for connection. I had set "gom"...
I did nothing than editing a big sql-statement: Program was still working System.AccessViolationException Es wurde versucht, im geschützten Speicher zu lesen...