Hi, I get the error when I click on Migration Yves Martel DBA DB2, Oracle, SqlServeur Service Architecture et Infrastructure des données Vice-présidence...
Hi, When I ALTER a TABLE, which have a RUNSTAT PROFILE, I get the RUNSTAT generated without the SET PROFILE option When I ALTER an MQTABLE I do not get the...
Hi Yves, The second item you identified has already been fixed and will be in the next beta. It was cr 226209 in case you're tracking these. And regarding the...
Why? And what exactly do you mean with an "unformatted number". I realize you mean that in this case you want it without the , character. But let us say this...
Thanks, It's fixed and will be in the next beta. ________________________________ From: toaddb2beta@yahoogroups.com [mailto:toaddb2beta@yahoogroups.com] On...
Yves, It appears we don't yet have support for profiles but it is already on the enhancement list. Thanks, Nancy ... the next beta. It was cr 226209 in case...
The obvious example is when I copy a number from one location to another to use lets say the value in a query where block. Formatting is typically reserved for...
We have the same issue with Toad for DB2 there is no Alter table - and its a constant battle to do table maintenace in Oracle we never had this problem. Steve ...
We have discussed this internally and will add an option on how to format numbers for the 4.0 release same as we do with dates. Unfortunately we are currently...
Is there a way to control the number of sheets a diagram prints across, currently my diagram always prints on a single sheet of paper making the objects and...
Hi Mark, Currently printing a diagram across pages is not supported. I created CR226669 as enhancement request. Thanks, Dan ________________________________ ...
This message is for Steve Adams & Yves Martel, I'm in QA for the Toad for DB2 product. I experienced a problem where I should of gotten an ALTER TABLE DDL...
Modified last 2 columns to not nullable, and the following script was generated. ... RUNSTATS TABLESPACE FDBMD.FTSUDTYP TABLE( FDBMD.USER_DOC_TYPES ) ...
For example, if you try to explain the following query, select * from syscat.tables where tabname = 3084 The only error you would get is "Explain plan not...
For example, we have the following list of packages. PKGSCHEMA PKGNAME PKGVERSION GRP_BCH_T_DB2 GC641140 2007-07-23-15.20.55.354817 GRP_BCH_T_DB2 GC641140...
Mark it appears that you are altering a DB2 on z/OS object, but the toad execution somehow is driving the runstats execution through the toad db2 on LUW logic....
Because of the Set Schema, Set User statements (See long history of how they cause me problems in the new group), I cut and paste the script into Control...
Sharon, Thank you for your comments. We do realize that there are some deficiencies in the Toad Explain processing including the issue that you have noted...
Sharon, I understand your issue and I assume you are working with an LUW DB2 database since the Z/OS package support is currently a little more intelligent and...
When altering a table with an identity column, the new table's identity is not updated to reflect the highest value inserted / copied from the old table. This...
If I try to alter a tables next available identity #, Toad builds an alter script as if I was changing the table structure as opposed to the simply creating...
Hi Mark, We will investigate this, CR226828 opened to track this issue. Regards, Dan ________________________________ From: toaddb2beta@yahoogroups.com...
... Hi Mark, Can you re-generate this script and run this from the Toad Editor and then send the results back? So far we have been unable to reproduce this...
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.
