Toad for IBM DB2 Beta Program Community

Toad for IBM DB2 - Beta Forum

Jeff Podlasek
Follow / 20 Jun 2017 at 1:19pm / Toad for IBM DB2 Beta Program
Latest post by on 27 Jun 2017 at 12:48am

Toad DB2 Beta

Expand content
Our last posted beta- Toad for DB2 Beta 6.3.0.232 - expires on July 17 and will be our last posted beta in the 6.3 series...

Our last posted beta-  Toad for DB2 Beta 6.3.0.232 - expires on July 17 and will be our last posted beta in the 6.3 series...

151 2 / Create an account to join the discussion.
Shimonj
Follow / 9 Apr 2017 at 6:59am / Toad for IBM DB2 Beta Program
Latest post by on 26 Jun 2017 at 6:38pm

An attempt to allocate a handle failed because there are no more handles...

Expand content
Hi, 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...

Hi,

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.

323 3 / Create an account to join the discussion.
yahya.nattagh
Follow / 15 Jun 2017 at 2:36pm / Toad for IBM DB2 Beta Program
Latest post by on 19 Jun 2017 at 1:01pm

DB Parameters error message

Expand content
Selecting "DB Parameters" tab for a LUW database fails with "ERROR [42884] [IBM][DB2/AIX64] SQL0440N No authorized routine named "DB_GET_CFG" of type "FUNCTION" having...

Selecting "DB Parameters" tab for a LUW database fails with "ERROR [42884] [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 6.3.0.232 (32 bit)

168 3 / Create an account to join the discussion.
Db2Developer
Follow / 5 Jun 2017 at 2:44pm / Toad for IBM DB2 Beta Program
Latest post by on 13 Jun 2017 at 2:02pm

Alter table script bad delimiter

Expand content
Good Morning, 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...

Good Morning,

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.

Error Message:

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 6.3.0.232 (64 bit) - TOAD for Db2 z/OS

241 3 / Create an account to join the discussion.
Db2Developer
Follow / 2 May 2017 at 3:23pm / Toad for IBM DB2 Beta Program
Latest post by on 5 Jun 2017 at 6:22pm

Bad Format on Date Import

Expand content
Hello, 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...

Hello,

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:

Book1.xlsx

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 [22007] [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 6.3.0.57 (64 bit)

571 9 / Create an account to join the discussion.
shiva444
Follow / 29 May 2017 at 10:50am / Toad for IBM DB2 Beta Program
Latest post by on 5 Jun 2017 at 3:15pm

Unable to connect to DB2 database using toad 6.3 beta version on windows...

Expand content
Getting the below error while connecting to DB2 database. System Information ********************************************************************** Operating System Microsoft Windows 7 Professional...

Getting the below error while connecting to DB2 database.

System Information
**********************************************************************
Operating System
Microsoft Windows 7 Professional 6.1.7600 AMD64

DB Details. 

**********************************************************************

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL09075" with
level identifier "08060107".
Informational tokens are "DB2 v9.7.500.4299", "special_27924", "IP23286_27924",

and Fix Pack "5".

*******************************************************************
Exception Information
**********************************************************************
Exception: System.EntryPointNotFoundException
Message : 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()

Requesting help.

269 3 / Create an account to join the discussion.
rgconrad
Follow / 31 May 2017 at 5:28pm / Toad for IBM DB2 Beta Program
Latest post by on 5 Jun 2017 at 3:13pm

DB2 connection fails

Expand content
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.ArgumentOutOfRangeException...

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.ArgumentOutOfRangeException
Length cannot be less than zero.
Parameter name: length
Stack 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!

164 1 / Create an account to join the discussion.
qiqiangzhu
Follow / 22 Feb 2017 at 3:45pm / Toad for IBM DB2 Beta Program
Latest post by on 31 May 2017 at 1:56pm

Installation failed on new Beta 6.3.0.508

Expand content
Tried to run an install (ToadForDB2_Beta_6.3.0.508) on a Windows 7 64bit box, an Error pops up immediately: "Could not load the DLL Library C:\Users\Administrator\AppData\Local\TempCustomActions...

Tried to run an install (ToadForDB2_Beta_6.3.0.508) on a Windows 7 64bit box, an Error pops up immediately:

"Could not load the DLL Library

C:\Users\Administrator\AppData\Local\TempCustomActions.dll.

The specified module could not be found."

Please advice.

Thanks

367 4 / Create an account to join the discussion.
Paul D
Follow / 30 May 2017 at 5:20pm / Toad for IBM DB2 Beta Program
Latest post by on 31 May 2017 at 3:03am

Beta Period for Toad for DB2 6.3 Expired

Expand content
Just wondering if I need to re-install or will 6.3 be released or is there an upcoming beta version.

Just wondering if I need to re-install or will 6.3 be released or is there an upcoming beta version.

Unanswered 163 1 / Create an account to join the discussion.
martin.ebneter
Follow / 12 May 2017 at 9:36am / Toad for IBM DB2 Beta Program
Latest post by on 22 May 2017 at 7:21am

Script for Table ist not showing up

Expand content
I try to display the script for a certain z/OS table in TOAD for DB2 (6.3.0.232 (32 bit)) but it will never been shown. There ist just a Line: "-- Generating script in background" showing up...

I try to display the script for a certain z/OS table in TOAD for DB2 (6.3.0.232 (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;

Unanswered 369 4 / Create an account to join the discussion.
Db2Developer
Follow / 7 Mar 2017 at 3:41pm / Toad for IBM DB2 Beta Program
Latest post by on 28 Apr 2017 at 3:07pm

re-size widget

Expand content
Hello, 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...

Hello,

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 6.3.0.508 (64 bit)

Thanks so much!

-Robert

398 5 / Create an account to join the discussion.
Jeff Podlasek

New Toad DB2 v6.3.0.232 beta drop is available

Expand content
We have just posted our Toad DB2 v6.3.0.232 beta drop. This drop contains our latest fixes for the product. Please download the latest beta from: http://www.toadworld.com/products/toad-for-ibm-db2...

We have just posted our Toad DB2 v6.3.0.232 beta drop. This drop contains our latest fixes for the product.

Please download the latest beta from:

http://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program/

Please post any beta feedback on the forum at:

http://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program/f/88

Thanks...

152 0 / Create an account to join the discussion.
Jeff Podlasek
Follow / 30 Mar 2017 at 9:33pm / Toad for IBM DB2 Beta Program
Latest post by on 17 Apr 2017 at 7:37pm

Toad DB2 v6.3 beta msi installers

Expand content
If you have issues installing with the exe - try these msi installers: http://community-downloads.quest.com/toadsoft/DB2/ToadForDB2_Beta_6.3.0.57.x86.msi http://community-downloads.quest.com/toadsoft...

If you have issues installing with the exe - try these msi installers:

http://community-downloads.quest.com/toadsoft/DB2/ToadForDB2_Beta_6.3.0.57.x86.msi


http://community-downloads.quest.com/toadsoft/DB2/ToadForDB2_Beta_6.3.0.57.x64.msi

Use the installer with the same bit-ness as your DB2 client....

316 3 / Create an account to join the discussion.
robert.krall
Follow / 10 Apr 2017 at 2:42pm / Toad for IBM DB2 Beta Program
Latest post by on 13 Apr 2017 at 6:36pm

Suggestion for TOAD

Expand content
Hello, I have a suggestion for TOAD and I think its pretty easy to make happen or I hope. Whenever I create stored procedures I always start my parameters with am '@' sign. When you right click...

Hello,

I have a suggestion for TOAD and I think its pretty easy to make happen or I hope.  

Whenever I create stored procedures I always start my parameters with am '@' sign.  When you right click and execute a proc within TOAD it will be default put an '@' in front of parameters.

My issue is I already have that '@' sign so now I have two of them.  

Here is an example: 

Is there any way we can have a check box to enable auto putting an '@' sign in variables or have the software look for them before doing the call?  

It just sucks my proc always fail when I use the gui to execute the proc.  Here is a sample DDL:

CREATE PROCEDURE sysproc.ParmExample(in @Parm1 varchar(500))
VERSION V1
LANGUAGE SQL
PARAMETER CCSID EBCDIC
DYNAMIC RESULT SETS 1
CALLED ON NULL INPUT
P1:
BEGIN
DECLARE RESULT_CSR CURSOR WITH RETURN FOR
Select @Parm1 as Parm1
from SYSIBM.SYSDUMMY1 SY;

--display result
open RESULT_CSR;

END P1#


GRANT EXECUTE ON PROCEDURE sysproc.ParmExample TO PUBLIC#

I just one more suggestion.  This is not causing an error, but it shows a red line for syntax error. 

I have changed my statement delimiter to a '#' sign, but when you right click and execute a proc it is using a ';' sign.  Is there anyway to make TOAD so it will use the delimiter you set in the settings of the application? 

here is a screen shot:

Thanks for much for your hard work on this product! I love all the  new features and glad to see active dev on the application.

I am using Toad for DB2 Beta 6.3.0.57 (64 bit) for z/OS.

173 2 / Create an account to join the discussion.
Jeff Podlasek

New Toad DB2 v6.3 beta drop is available

Expand content
We have just posted our Toad DB2 v6.3.0.57 beta drop. (We had to renumber our beta builds so this build number is less than the previous drop's but do not worry - it is the latest). Please download...

We have just posted our Toad DB2 v6.3.0.57 beta drop.

(We had to renumber our beta builds so this build number is less than the previous drop's but do not worry - it is the latest).

Please download the latest beta from:

http://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program/

Please post any beta feedback on the forum at:

http://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program/f/88

Thanks...

148 0 / Create an account to join the discussion.
Shimonj
Follow / 18 Jan 2017 at 11:16am / Toad for IBM DB2 Beta Program
Latest post by on 14 Feb 2017 at 10:13am

Export to Excel has different behavior in 6.3

Expand content
Hi, We have a automation script that writes to an excel file. In 6.2 the Header fields are the proper width. When I run the same script in 6.3, the column width in Excel are narrower and the headers...

Hi,

We have a automation script that writes to an excel file. In 6.2 the Header fields are the proper width. When I run the same script in 6.3, the column width in Excel are narrower and the headers are not displayed. 

We did not change the Office installation. I'm wondering why this is so, and if you can fix this please. 

I'm keeping 6.2 ( and running my automation scripts there) for this reason.

Sincerely,

Shimon J.

622 9 / Create an account to join the discussion.
Shimonj
Follow / 24 Jan 2017 at 9:10am / Toad for IBM DB2 Beta Program
Latest post by on 30 Jan 2017 at 9:29pm

Suggestion for improvment - Results of selects run via automation

Expand content
Hi, I think I already suggested that it would be a great help if I could run a query on several schemas / environments and be able to save or review the results. Another help would be if there would...

Hi,

I think I already suggested that it would be a great help if I could run a query on several schemas / environments and be able to save  or review the results. 

Another help would be if there would be a search feature in the result window. When I run a update I add a select statement to verify that the update has the result that I expected. I have to scroll through the results to see how many rows the select returned. It would be easier use find and search for "rows found".

Another thing I noticed is that only if the select is the last statement in the script is the resulting "rows found"  written to the results window. It would be more effective if I could add a select before and after the update statement and see the amount of rows found before and after the update.

Thanks alot,

Shimon J.

311 1 / Create an account to join the discussion.
Jeff Podlasek

new Toad DB2 v6.3.0.508 beta is posted

Expand content
We posted an updated Toad DB2 beta - v6.3.0.508. Please visit the beta page to download the latest beta drop at: http://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program/...

We posted an updated Toad DB2 beta - v6.3.0.508.

Please visit the beta page to download the latest beta drop at:

http://www.toadworld.com/products/toad-for-ibm-db2/toad_for_ibm_db2_beta_program/

To view the changes in our latest beta drop, please review the latest beta release notes at:

http://dev.toadfordb2.com/releasenotes/beta/toaddb2betarn.pdf

214 0 / Create an account to join the discussion.
Shimonj
Follow / 30 Jan 2017 at 1:59pm / Toad for IBM DB2 Beta Program

Compare Data on CLOB results in Insert and Update statements

Expand content
Hi, When comparing the data between two schemas and a row containing a CLOB exists in the source, choosing "make target like source" results in two statements. The first one is an Insert statement...

Hi,

When comparing the data between two schemas and a row containing a CLOB exists in the source, choosing "make target like source" results in two statements. The first one is an Insert statement with part of the of CLOB and a second statement updating the CLOB using || ( adding the rest of the text to the existing content of the CLOB). This is very handy where the CLOB is bigger than 32K, When the content is less than 32K the same could be attained by a single Insert.

The reason this bothers me is that if the record exists already, the result is that the reulting CLOB is updated and un-usable. 

A practical solution is to to create either only an Insert or an an Insert with two updates, verifyng that the resulting cell contains exactly what the source cell contains even if the record exists.

You may wonder how could the record exist if the compare decided on an Insert? The answer is that I have an automation script running the resulting statement on many schemas ( including the source). 

238 0 / Create an account to join the discussion.
martin.ebneter
Follow / 20 Jan 2017 at 1:14pm / Toad for IBM DB2 Beta Program
Latest post by on 23 Jan 2017 at 7:14pm

DB2 z/OS: Database Information not shown in "Dependencies"...

Expand content
For all objects (tables, views, tabelspaces, Indexes, etc.) the DATABASE Information in the "Dependencies"-Tab ist not shown, on any Level.

For all objects (tables, views, tabelspaces, Indexes, etc.) the DATABASE Information in the "Dependencies"-Tab ist not shown, on any Level.

303 1 / Create an account to join the discussion.