Hello, When the CREATE NICKNAME is executed, if the federated table has a primary key, then this primary key definition will be reflected in the DB2 catalog. ...
Hello Yves, You dropped nickname but not dropped constraint before. (Such amazing behavior) Accordingly IBM, - it's their issue (PMR 30432,756,000) that will...
Hello, Some nodes are not recognized by TOAD for DB2 but the are by Quest Central for DB2 ! Please, don't tell me to UNCATALOG/CATALOG Yves Martel DBA DB2,...
Quest Central for DB2 works with the default DB2 copy installed on your Windows machine. Toad installs its own 'Client only' DB2 V9 copy and as such has its...
Thanks, it works fine :-) Yves Martel DBA DB2, Oracle, SqlServeur Service Architecture et Infrastructure des données Vice-présidence Architecture et...
Yves, I don't know if it will be fixed for V8. We just got db2cleancat script for our environment (our test database) and promise this to be fixed in V9. ...
Today I can not use TOAD :-( ...but I can use Quest Central for DB2 and CMD line and DB2 CC :-) At Toad startup From the connection tab ...then TOAD...
Yes, it can happen that the connection is going fine with QcDB2 while you need to set catalog entry for toad. Actually Quest Central for DB2 works with the...
Hello Everyone: Toad DB2 V3.0 is now GA. I'd like to thank all of our beta testers for all the feedback they gave us for this release, especially Mark Stone,...
The schema is showing different data types in the tree view (e.g STATUS is showing Varchar <> Decimal), but the code view on the right shows the datatypes as...
Mark, Thanks for the post. Can you let me know what build number you are using? Also, can you confirm that that the DDL on the right side is showing up ...
<<ToadSupportBundle.zip>> ... From: Harris, Gordon Sent: Monday, August 06, 2007 4:59 PM To: Adams, Steve W Subject: Exception opening alter table dialog for...
Steve, Thanks for the report. To assist in our problem determination can you try a few things? 1) right click and select alter on this table - do you get the...
984, yes it looked good, these false positives seems to be happening across multiple SP's ________________________________ From: toaddb2beta@yahoogroups.com...
<<ToadSupportBundle.zip>> None ******************************************************************************** Exception Information ...
Paul Knowles
paul.knowles@...
Aug 8, 2007 3:23 pm
1305
1) right click and select alter on this table - do you get the same error? YES 2) select the table in the browser and click on the 'script' tab - do you...
Hi Jeff, Could you also send the DDL for your table? see Below... CREATE TABLE CRIMES.P_ADDRESS_PHONE ( USER_ID VARCHAR(25) FOR SBCS DATA NOT NULL, P_ROW_ID...
Thanks - this information is helpful - we are investigating and I will keep you posted on what we find. Jeff ... [mailto:toaddb2beta@yahoogroups.com] ... ...
Mark, We have discussed this and investigated this internally. Currently SP parms are compared by position, and we are showing misleading information about...
Paul, can you provide a bit more information in order to assist us here. - can you send in the DDL of the table you are querying - how did you query the table...
Steve - I've identified the problem. It's in the way the Table editor is handling the P_ROW_ID identity column. I'm guessing that you're getting this error...
Steve - I meant to say that you can ALTER (not recreate) the table column and set the MAXVALUE for the identity column: ex: ALTER TABLE <tabname> ALTER COLUMN...
Steve, This looks as though it could be a bug and we are investigating this. Thanks for reporting this. I will inform you when this has been addressed. Thanks...
Hi Jeff, I appreciate the response. Please keep us posted - for us the wrapping and code formatting issues are critical to readability and thus maintainability...
I have placed a development database objects under VSS control. I like the functionality, but it seems to take forever for Toad to update the version control...
Hi! currently testing the newest beta build (984). I am in desperate need for CVS integration. Currently there is only VCS. CVS integration was in an earlier...
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.
