You will no longer receive e-mail notifications from this forum.
Log-In to post
When comparing data between two schemas, if one of the fields is a CLOB and there is a difference in aonther field, the resulting update script includes an update of the CLOB field that results in erroneous data.
The update stataement does not replace the data with the data from the source but it adds part of the data to what already exists.
This behavior is similar to what I complained about here:
Whereas that was anuisance reaulting in the way I used the resulting script, the issue I have here is clearly a BUG.
The find and replace dialog.
We just upgraded TOAD and the Find and Replace Dialog is no-longer undocked.
I don't like it being fixed in place. It reduces my vertical real estate on my screen.
How do I undock it?
We just posted the Toad DB2 v6.5 Beta 188.8.131.52.
That beta drop contains several fixes and extends the beta expiration into December, 2017.This installer now has a new option that can prohibit users from saving their connection profile passwords.Please try out this new drop and let us know what you think.
You can download this new beta at:
I've run into this problem several times in the last few days. Using the Compare Data wizard, I am not able to enter a WHERE clause.
I have started using the new beta version (184.108.40.206) of TOAD and have to say I can't wait for it to go live! I really enjoy the save script to PDS member!
I noticed one issue and I am not sure if its a set up issue or not. When I started Toad for the first time it usually asks me to import my settings from an older version but never did this time so I am not sure I missed the setting to enable this feature or not. I always set up TOAD to color my background based on the connection of the database I am using. This works great helping when I am working in different environments such as development, model and production.
In version 6.3 the object explorer would so be colored based on connection, but now it seems to always stay white. Is this a setting I need to change or was its it a built in feature? I thought it was a feature. There are a few settings I change out of the gate when I first start using Toad so I might have missed it.
Thanks for your help! And keep up the great work.
We just posted the Toad DB2 v6.5 Beta 220.127.116.11.
That beta drop contains several fixes and extends the beta expiration to November 3, 2017.
You can download that beta at:
We are pleased to announce the beginning of the Toad for DB2 v6.5 beta program.
Please visit the beta program page at:
..to view the release notes and download the beta installer.
Some product highlights:
- For tables, indexes and tablespace, Toad now has a new object 'Overview' tab that can be customized to display information about those objects that you feel is important - on one tab!
- Dashboards have been enhanced to include a new 'Live Query' scroll-able and resize-able widget and now include the ability to quickly clone dashboards
- In the SQL Editor feature, DB2 z/OS users in can now read scripts from and write scripts to Partitioned Dataset (PDS) members on the mainframe
The beta release notes contain information on all new enhancements and features.
Please try the new beta and provide any feedback in the beta forum
Our last posted beta- Toad for DB2 Beta 18.104.22.168 - expires on July 17 and will be our last posted beta in the 6.3 series...
Somtimes I need to assign a few thousand ID's ( for copying a *** of records from one environment to another). The way to do this is to incremet the sequence of DB2, assuring that no other client will insert into the ID range that I will get.
When I tried getting a NEXTVAL a few thousand times, I recieved an error.
Today this happened again when I ran a statement to update the sequence to the MAX ID that I created by copying records. According to our DB2 expert, the error was coused by the Toad driver.
Selecting "DB Parameters" tab for a LUW database fails with "ERROR  [IBM][DB2/AIX64] SQL0440N No authorized routine named "DB_GET_CFG" of type "FUNCTION" having compatible arguments was found."
Thank you for great work on this new version.
Toad for DB2 Beta 22.214.171.124 (32 bit)
I recently came across the functionality that TOAD will create alter scripts for you via the GUI (Right click on Table --> Alter table --> Change table settings) and an alter script is created.
It corrects pretty good! There is a small issue with it though. My script is 125 lines long right now and one of the statements has the wrong delimiter for an odd reason. I think its just a issues with how the script is created. I have changed my delimiter so # sign, but its using ; sign one line. Here is a screen shot from a code preview.
I think this is a fairly easily fix; most likely an over site.
Thanks for all the hard work with TOAD!
Toad for DB2 Beta 126.96.36.199 (64 bit) - TOAD for Db2 z/OS
I have another suggestion (Or maybe there is a setting I need to turn one). I think this will be an easy one, but correctly its causing a lot of issues for me.
I have a table in DB2 with a column defined as a varchar(120) but when I upload a spreadsheet its reformatting the date field as a time stamp with a bad formatting for db2 time stamp format.
Let me explain in greater detail.
Here is the Table DDL:
CREATE TABLE DateTEST ( ColA varchar(120) )
Here is the spreadsheet:
I am using the import wizard (which I Love and its a great you can create templates and just fire those templates off whenever you want).
Here is screen one of the wizard:
As you can see its keeping the format of Date. Now when we go the next screen its re-formatting the data to this:
Here is the results in the table:
The problem with this format is DB2 can't cast it as a date as I need it in the format of date when I push to final table.
When you run this SQL: Select cast(cola as date) from DateTEST
You get this error: Lookup Error - DB2 Database Error: ERROR  [IBM][DB2] SQL0181N The string representation of a datetime value is out of range.
My suggestion is can you keep it as a date field and not convert the value to a time stamp? Or better yet can you rather format the time stamp as what is stated in the settings?
Such as this:
I know Dates and Time stamps are hard to use in Db2 for z/OS if they are not formatted correctly.
Thanks again for bringing a great product to us.
Toad for DB2 Beta 188.8.131.52 (64 bit)
Getting the below error while connecting to DB2 database.
System Information**********************************************************************Operating System Microsoft Windows 7 Professional 6.1.7600 AMD64
DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL09075" withlevel identifier "08060107".Informational tokens are "DB2 v9.7.500.4299", "special_27924", "IP23286_27924",
and Fix Pack "5".
*******************************************************************Exception Information**********************************************************************Exception: System.EntryPointNotFoundExceptionMessage : Unable to find an entry point named 'SQLFreeConnAttribsADONET' in DLL 'db2app.dll'.Stack Trace: at IBM.Data.DB2.UnsafeNativeMethods.DB232.SQLFreeConnAttribsADONET(DB2SQLGetConnAttribsADONETParams& pParam) at IBM.Data.DB2.ConnSettingsFromXmlConfig.Dispose(Boolean disposing) at IBM.Data.DB2.ConnSettingsFromXmlConfig.Finalize()
Getting the same error in v6.0, 6.2 and 6.3. I created a new DB2 connection from a cataloged connection; when trying to open in 6.0 and 6.2 it dumps the stack trace:
System.ArgumentOutOfRangeExceptionLength cannot be less than zero.Parameter name: lengthStack Trace: at IBM.Data.DB2.DB2ConnPool.Open(DB2Connection connection, String& szConnectionString, DB2ConnSettings& ppSettings, Object& ppConn) at IBM.Data.DB2.DB2Connection.Open() at Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection) at Quest.Toad.DB2.DB2ToadConnection.OpenConnection(IDbConnection connection) at Quest.Toad.Db.Connection.AllocConnection() at Quest.Toad.Db.Connection.Connect(Boolean notify) at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()
In 6.3 is appears to swallow the exception, but when I set the connection to connect at startup it displays:
(1) COT2 : Length cannot be less than zero.Parameter name: length
Installation is on Windows Server 2012 R2 virtual machine with .NET 4.6.01055. I have the exact installation and .NET version on a Windows 7 machine that works fine, not sure what's different with this installation. I'm using an AD account with local admin access on both machines. Thanks for any help!
Tried to run an install (ToadForDB2_Beta_184.108.40.2068) on a Windows 7 64bit box, an Error pops up immediately:
"Could not load the DLL Library
The specified module could not be found."
Just wondering if I need to re-install or will 6.3 be released or is there an upcoming beta version.
I try to display the script for a certain z/OS table in TOAD for DB2 (220.127.116.11 (32 bit)) but it will never been shown.There ist just a Line: "-- Generating script in background" showing up and a Task ist running in the backgrout that cannot be canceled.The same happens when I try to extract the DDL.
I tried to do the same in Toad 6.2. There I got a display but with a small error.There is a extra ' in front of the last X'FF': PARTITION 22 ENDING AT (X'FF',X'FF','X'FF') )
CREATE TABLE "#DB26DA1".OHPS_ADRESSE ( PARTNER_NR INTEGER NOT NULL, ADRESS_NR SMALLINT NOT NULL, ERFASSZEIT_TS TIMESTAMP NOT NULL WITH DEFAULT, ART_CD SMALLINT NOT NULL WITH DEFAULT, SPRACH_CD SMALLINT NOT NULL WITH DEFAULT, ZUSTELL_CD SMALLINT NOT NULL WITH DEFAULT, ADRESSZUS CHARACTER(35) FOR SBCS DATA NOT NULL WITH DEFAULT, STRASSE CHARACTER(35) FOR SBCS DATA NOT NULL WITH DEFAULT, HAUSNUMMER CHARACTER(10) FOR SBCS DATA NOT NULL WITH DEFAULT, HNRDAR_CD SMALLINT NOT NULL WITH DEFAULT, POSTFACH CHARACTER(10) FOR SBCS DATA NOT NULL WITH DEFAULT, PLZ CHARACTER(10) FOR SBCS DATA NOT NULL WITH DEFAULT, PLZ_ZUS CHARACTER(2) FOR SBCS DATA NOT NULL WITH DEFAULT, ORT CHARACTER(30) FOR SBCS DATA NOT NULL WITH DEFAULT, KANTON_CD SMALLINT NOT NULL WITH DEFAULT, GEMEINDENR CHARACTER(5) FOR SBCS DATA NOT NULL WITH DEFAULT, PROVINZ CHARACTER(35) FOR SBCS DATA NOT NULL WITH DEFAULT, LAND_CD SMALLINT NOT NULL WITH DEFAULT, KOMBZEIL_CD SMALLINT NOT NULL WITH DEFAULT, ANREDE_CD SMALLINT NOT NULL WITH DEFAULT, TITELDAR_CD SMALLINT NOT NULL WITH DEFAULT, VORNDARST CHARACTER(30) FOR SBCS DATA NOT NULL WITH DEFAULT, NAMEDAR_CD SMALLINT NOT NULL WITH DEFAULT, NZUSDAR_CD SMALLINT NOT NULL WITH DEFAULT, NOTIZ CHARACTER(70) FOR SBCS DATA NOT NULL WITH DEFAULT, GLTAB_DT DATE NOT NULL WITH DEFAULT, GLTBIS_DT DATE NOT NULL WITH DEFAULT, ERFASSER CHARACTER(8) FOR SBCS DATA NOT NULL WITH DEFAULT, SPRACHCODE CHARACTER(1) FOR SBCS DATA NOT NULL WITH DEFAULT, ORT_ZUSATZ CHARACTER(35) FOR SBCS DATA NOT NULL WITH DEFAULT, INTKFZ CHARACTER(3) FOR SBCS DATA NOT NULL WITH DEFAULT, POSTFACH_DEF SMALLINT NOT NULL WITH DEFAULT, HIST_TS TIMESTAMP WITH DEFAULT ) PARTITION BY RANGE ( PARTNER_NR, ADRESS_NR, ERFASSZEIT_TS ) ( PARTITION 1 ENDING AT (10399999), PARTITION 2 ENDING AT (10799999), PARTITION 3 ENDING AT (11199999), PARTITION 4 ENDING AT (11599999), PARTITION 5 ENDING AT (11999999), PARTITION 6 ENDING AT (12399999), PARTITION 7 ENDING AT (12799999), PARTITION 8 ENDING AT (13199999), PARTITION 9 ENDING AT (13599999), PARTITION 10 ENDING AT (13999999), PARTITION 11 ENDING AT (14399999), PARTITION 12 ENDING AT (14799999), PARTITION 13 ENDING AT (14999999), PARTITION 14 ENDING AT (15199999), PARTITION 15 ENDING AT (15399999), PARTITION 16 ENDING AT (15599999), PARTITION 17 ENDING AT (15799999), PARTITION 18 ENDING AT (15999999), PARTITION 19 ENDING AT (16199999), PARTITION 20 ENDING AT (16399999), PARTITION 21 ENDING AT (16599999), PARTITION 22 ENDING AT (X'FF',X'FF','X'FF') ) IN DPSH002.SPSH019 AUDIT NONE DATA CAPTURE NONE NOT VOLATILE APPEND NO;
I just installed the latest beta version of TOAD. So far its pretty sweet! I am digging the widgets.
I was wondering if there was a future plan to allow you to re-size widgets? I created one with some SQL but it's outputting 8 columns and the widget only shows the first 4.
Toad for DB2 Beta 18.104.22.1688 (64 bit)
Thanks so much!
We have just posted our Toad DB2 v22.214.171.124 beta drop. This drop contains our latest fixes for the product.
Please download the latest beta from:
Please post any beta feedback on the forum at:
If you have issues installing with the exe - try these msi installers:
Use the installer with the same bit-ness as your DB2 client....