Marc, Can you clarify for me what you mean by "a new separate connection is being opened"? Do you mean that the editor with the extracted DDL is opened with a...
Hi Nancy, 1st step: Selecting a STP from Schemabrowser (note the connection info reads "LOGI_LS (ELIX)" 2nd step: calling Extract DDL wizard 3. The newly...
Thanks Marc. That was helpful to see the screen shots. Although I couldn't reproduce it myself, I did open CR 61018 to see if this can be tracked down. Thanks...
I attempted to create an index on a table. It has 23 columns and the index was 22 columns. The following error occurred. It reported an error stating the...
Hello Mark, Was the statement that failed targeting a federated database? Since this is a DB2 error message and it worked on one database and not on another,...
Hi, I was trying to install the beta version of sql optimizer for db2 luw version 3_474 and the installation complains about insufficient privileges to...
Padma, I am going to create a new thread for you question because it does not seem related to this thread. Ken Ryan Product Developer Quest Software...
(Note: I moved this question from a previous thread to this new one) Hi, I was trying to install the beta version of sql optimizer for db2 luw version 3_474...
Padma, Can you send a screen shot of the error, please? In the meantime, I will try to recreate this error? Thanks Ken Ryan Product Developer Quest Software...
Padma, Can you send a screen shot of the error, please? In the meantime, I will try to recreate this error? Thanks Ken Ryan Product Developer Quest Software...
Hi! Connection Dialog: Mark two or more connections and press Connect expectation: All marked Connections will be connected real effect: Only the last marked...
Hi! Why did you remove the option to rename an Editor Window? So I could give them some names like "Conn1" and "Conn2" or similar for a better distinction... ...
Hi! what happend to the nice "First-Aid"-Symbol for Explain Plan Functionality??? Comming from 3.1 to 4.0 it changed from a ambulance Symbol to a simple...
Hi there! I am using Toad for Analyze of Database-Migrations. Sometimes I need to run a Query against to Databases in the way to compare one Primary Key to...
Claus, I was able to recreate this issue, and I have created cr61467 to address it. Thank you for reporting it. Ken Ryan Product Developer Quest Software...
Claus Thanks for your feedback. In Toad DB2 you can optionally have connection information dislayed on the document tabs. Navigate to Tools | Options |...
Claus Toad DB2 has a group execution feature available in any SQL Editor tab. To use this feature, when you have an editor opened - you can right click in the...
Claus, You can also look at the Compare Data Wizard to see if that will help you sync data between the two DB2 instances. You can access Compare Data by...
Hi Jeff! yes I found allready this GroupExecute-Option. But this will run ONE Script against MANY Databases... My problem is different. I have ONE Script which...
I think this wont work either... I have two different Tabletypes. One is in an old format (like denormalized) and the new one is mor objectorientated. So I...
Hi there! sometimes Toad 4.5 beta doesn't show me available Columns of a table trying to make a big SQL like: select * from tablea a , tableb b , tablec c ...
Claus, From the query you are using... select * from Tableold where not exists (select 1 from tableNEW where PK_OLD = PK_NEW) ... I don't see why Compare Data...
Hi! I have another suggestion about resultsets... I often have to copy a Single Key from a Resultset. Most times its a Character and therefore I have to...
Hi! First: Nice one -> Skript result in One "Set x" and every single Statement on the left-> Nice ! Very Nice! But... its a little bit dodgy to find which...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
