Danny Torres
Follow / 14 Sep 2016 at 7:08pm / Toad for IBM DB2

Toad for DB2 - How to get the most out of this forum – Best practices...

Expand content
The better a problem is described, the better the assistance tends to be. In order to better assist with your issue at hand, please include the following information in your initial post: - Product...

The better a problem is described, the better the assistance tends to be.

In order to better assist with your issue at hand, please include the following information in your initial post:

 

-          Product, Version, and relevant environment details.

-          Include a screenshot of the problem

-          Describe the problem fully. What result was expected?

-          Can the issue be created on demand or is it intermittent?

-          If the problem can be generated faithfully, what are the exact steps to recreate the problem?

-          Any other pertinent information (see below)

 

Create Support Bundles

 You can create a support bundle and send it to Dell Support or to the Toad for IBM DB2 community Web site (peer-to-peer support). The support bundle provides information (about your application and the database) that is used to help troubleshoot problems.

 Select Help | Support Bundle. It may take time for Toad to generate the support bundle depending on your system configuration.

 

 Create Support Bundle for a SQL Query Issue

 If your issue is a SQL query issue, it is helpful if additional log files are included in the support bundle. These log files are automatically included if you generate a support bundle immediately after executing the query in either the Editor or Query Builder.

 To create a support bundle for a SQL query issue

1. In the Editor or Query Builder, reproduce the error or issue.

2. After reproducing the error, immediately select Help | Support Bundle to generate a support bundle.

3. Toad asks if you want to log the row count for each table used in the query. If you select Yes, Toad determines the size of each table used in the query. This adds additional time to the generation process, but also provides additional information about your issue.

 4. When Toad is finished generating the support bundle attach log.

  

Note: For best results, always send the entire support bundle. This provides Support with the most information about your issue and aids the troubleshooting process.

*Note: Please refrain from including private data in your posts

Be as thorough as you can with the provided info. We will reply to you as quick as possible. We are glad to assist you

 

Latest Release Information:

 This announcement includes information on our latest releases, links to our downloads and documentation and overview of new features.  This way you can stay as informed as possible:

 -          What’s New Section (why they would want to pay attention to this new version)

https://support.software.dell.com/toad-for-db2/release-notes-guides

-          Link to Download & Documentation

https://support.software.dell.com/toad-for-db2/6.2

-          Link to Trial (if applicable)

https://software.dell.com/register/54941

-          Overview of new feature(s) (with link to the release notes)

https://support.software.dell.com/toad-for-db2/release-notes-guides

 

 

Top 5 Knowledge Base Articles:

 On this post, you can find our top trending knowledge articles that other customers are inquiring about and popular solutions.

 This month’s Top Knowledge Base Articles

  1. What is new in Toad for DB2 Suites 6.2. (196996) https://support.software.dell.com/toad-for-db2/kb/196996
  2. Where can I find the License Number for Toad for DB2? (211767) https://support.software.dell.com/toad-for-db2/kb/211767
  3. VIDEO - Overview of the new dashboard features in Toad for DB2 (157889) https://support.software.dell.com/toad-for-db2/kb/157889
  4. Connection, Installing LUW cannot create a catalog entry (210787) https://support.software.dell.com/toad-for-db2/kb/210787
  5. Getting Error SQLSTATE=07001 when executing query with parameters (212011) https://support.software.dell.com/toad-for-db2/kb/212011

  Feel free to browse them. Remember to sign in to your account to view.

1219 0 / Create an account to join the discussion.
mojoala
Follow / 14 Aug 2017 at 3:23pm / Toad for IBM DB2
Latest post by on 21 Aug 2017 at 2:03pm

Build a Where Clause in a Stored Procedure and then Use it in a Select...

Expand content
Is this even possible. I've scoured the internet and can't find an answer. BEGIN Declare WhereClause VarChar(4000); Declare Main VarChar(3500); Declare SubMain VarChar(500) BEGIN Select...

Is this even possible.  I've scoured the internet and can't find an answer.

BEGIN

Declare WhereClause VarChar(4000);

Declare Main  VarChar(3500);

Declare SubMain VarChar(500)

BEGIN         

Select Prev_Month_St_Dt Into BegOfPrevMon From TMSR_DATA_DATES;

Select Prev_Month_End_Dt Into EndOfPrevMon From TMSR_DATA_DATES;

Select Month(Prev_Month_St_Dt) Into CurMon From TMSR_DATA_DATES;

Select Day(Prev_Month_End_Dt) Into LastDay From TMSR_DATA_DATES;

Set Main = "Yada Yada...."  ---about 50 lines of codes

Set SubMain to some other based on the select into values....about another 50 lines of code....

Set  WhereClause = Main || SubMain;

END;

BEGIN

DECLARE C1 CURSOR WITH RETURN TO CLIENT FOR

Select yada yada yada From -- 500 lines of code

        Insert the WhereClause here

UNION

Select  yada yada yada From -- 500 lines of code

   Insert the WhereClause here

OPEN C1;

END;

END!

 

 

 

Unanswered 77 3 / Create an account to join the discussion.
glenn.venkatramani
Follow / 18 Aug 2017 at 11:01pm / Toad for IBM DB2
Latest post by on 20 Aug 2017 at 9:12pm

No default 64 bit db2 client was found

Expand content
Hi I joined this company 6 months before and I installed this Toad. My company has 3 seat license. I installed and applied the license and all good. Now when I try to connect it says that there is no 64...

Hi I joined this company 6 months before and I installed this Toad. My company has 3 seat license. I installed and applied the license and all good. Now when I try to connect it says that there is no 64 bit db2 client. How can I achieve this. 

70 3 / Create an account to join the discussion.
kavxps
Follow / 2 Jan 2015 at 9:47am / Toad for IBM DB2
Latest post by on 20 Aug 2017 at 2:10pm

No default DB2 client

Expand content
I have installed Toad 6 freeware for WIN32 but not able to proceed with setting up connections. It asks for a client on application start. Is there a separate windows installer which is required or should...

I have installed Toad 6 freeware for WIN32 but not able to proceed with setting up connections. It asks for a client on application start. Is there a separate windows installer which is required or should there be a DB2 JAR (or a similar driver) in the installation directory ?

Answered 31212 24 / Create an account to join the discussion.
K Perry
Follow / 24 Jul 2017 at 9:06pm / Toad for IBM DB2
Latest post by on 31 Jul 2017 at 9:47am

TOAD for DB2 - Getting Stack Trace Error in V3.3.0.1526

Expand content
I am receiving the following error when I log into TOAD for DB2: System.BadImageFormatException Could not load file or assembly 'Quest.Data.DB2.Admin.dll' or one of its dependencies. Invalid...

I am receiving the following error when I log into TOAD for DB2:

System.BadImageFormatException
Could not load file or assembly 'Quest.Data.DB2.Admin.dll' or one of its dependencies. Invalid access to memory location. (Exception from HRESULT: 0x800703E6)
Stack Trace:
   at Quest.Toad.DB2.DB2ConnectionControl.RefreshCatalog()
   at Quest.Toad.DB2.DB2ConnectionControl.InitDB2Data()
   at Quest.Toad.DB2.DB2ConnectionControl.InitUI(ConnectMediator connectOptions, ConnectionFormStyle displayStyle)
   at Quest.Toad.ConnectionManager.ConnectionPropertiesControl.CreateContainer(ConnectMediator connectOptions)
   at Quest.Toad.ConnectionManager.ConnectionPropertiesControl.ShowContainer(ConnectMediator connectMediator)
   at Quest.Toad.ConnectionManager.ConnectionPropertiesControl.AssignConnectOptions(Node node, ConnectionFormStyle style)
   at Quest.Toad.ConnectionManager.ConnectionForm.RefreshUI()
   at Quest.Toad.ConnectionManager.ConnectionForm.connectionControl1_FocusChange(Object sender, ConnectionControlSelectionArgs e)
   at Quest.Toad.ConnectionManager.ConnectionControl.RaiseFocusChanged(Node node)
   at Quest.Toad.ConnectionManager.ConnectionControl.connectionList_FocusedNodeChanged(Object sender, FocusedNodeChangedEventArgs e)
   at DevExpress.XtraTreeList.TreeList.RaiseFocusedNodeChanged(TreeListNode oldNode, TreeListNode newNode)
   at DevExpress.XtraTreeList.TreeList.InternalSetFocusedRowIndex(Int32 newFocusedRowIndex)
   at DevExpress.XtraTreeList.TreeList.set_FocusedRowIndex(Int32 value)
   at DevExpress.XtraTreeList.TreeList.SetFocusedNode(TreeListNode node)
   at DevExpress.XtraTreeList.TreeList.set_FocusedNode(TreeListNode value)
   at Quest.Toad.ConnectionManager.ConnectionControl.SelectTreeNode(TreeListNode treeNode)
   at Quest.Toad.ConnectionManager.ConnectionControl.SelectTreeNode(ConnectMediator connectInfo)
   at Quest.Toad.ConnectionManager.ConnectionForm.InitializeForm(ConnectMediator connectInfo, Boolean allowReconnect, Boolean hideGroups)
   at Quest.Toad.ConnectionManager.ConnectionForm..ctor(ConnectMediator connectInfo, Boolean allowReconnect)
   at Quest.Toad.ConnectionManager.ConnectionForm.ShowConnectionDialog(ConnectMediator connectInfo, Boolean allowReconnect)
   at Quest.Toad.Gui.MainForm.bbiShowConnectionsDialog_ItemClick(Object sender, ItemClickEventArgs e)
   at DevExpress.XtraBars.BarItem.OnClick(BarItemLink link)
   at DevExpress.XtraBars.BarBaseButtonItem.OnClick(BarItemLink link)
   at DevExpress.XtraBars.BarItemLink.OnLinkClick()
   at DevExpress.XtraBars.BarItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)
   at DevExpress.XtraBars.BarButtonItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)
   at DevExpress.XtraBars.BarItemLink.OnLinkActionCore(BarLinkAction action, Object actionArgs)
   at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.ClickLink(BarItemLink link)
   at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.UnPressLink(BarItemLink link)
   at DevExpress.XtraBars.Controls.CustomLinksControl.OnMouseUp(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at DevExpress.XtraBars.Controls.DockedBarControl.WndProc(Message& msg)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

This is preventing me from connecting to any database.

92 1 / Create an account to join the discussion.
dkirby
Follow / 28 Jul 2017 at 11:02pm / Toad for IBM DB2
Latest post by on 30 Jul 2017 at 8:55pm

FTP UPLOAD

Expand content
I am trying to use toad TAS file do an upload a csv to an ftp site. i am able to upload using another Utility, but toad is giving me a FTP_1 - Could not create file. (code=553) error. it is basically telling...

I am trying to use toad TAS file do an upload a csv to an ftp site.  i am able to upload using another Utility,  but toad is giving me a FTP_1 - Could not create file. (code=553) error.  it is basically telling me i dont have access to write to the remote location.  As i said, i can write to it using another utility so i know it is not permissions.   Is there some setting in the ftp setup that i am missing?  maybe a setting or configuration in options or setup?

any help would be great. 

Thanks

139 3 / Create an account to join the discussion.
s.guerin
Follow / 26 Jul 2017 at 6:10pm / Toad for IBM DB2
Latest post by on 26 Jul 2017 at 10:24pm

Toad for DB2 Freeware edition - 32 bits version

Expand content
Hello, Is there any 32 bits version available for Toad for DB2 Freeware edition 6.3? Best regards.

Hello,

Is there any 32 bits version available for Toad for DB2 Freeware edition 6.3?

Best regards.

144 1 / Create an account to join the discussion.
Deepshika
Follow / 8 Mar 2017 at 10:45am / Toad for IBM DB2
Latest post by on 25 Jul 2017 at 3:02pm

"Processing was cancelled due to an interrupt" with SQL...

Expand content
Hi all, "Processing was cancelled due to an interrupt" with SQL0952N I have already googled and tried resolving the issue one was asking me to update the QUERYTIMEOUTINTERVAL=0 in the...

Hi all,

"Processing was cancelled due to an interrupt"

with SQL0952N

I have already googled and tried resolving the issue

one was asking me to update the QUERYTIMEOUTINTERVAL=0 in the db2cli.ini file.

which I have already done .however, there was no improvement

Moreover, when i tried to resolve the issue from application and bypass the issue by using the CommandTimeout=0; then, it is not throwing the exception. However, we are not getting the desired output as well.

Please help me out.

Thanks,

Deepshika

Unanswered 477 3 / Create an account to join the discussion.
Deepshika
Follow / 13 Apr 2017 at 11:17am / Toad for IBM DB2
Latest post by on 25 Jul 2017 at 2:18pm

Reducing the HWM in DMS Table Spaces in db2 9.5 version

Expand content
hi all I want to reduce the DMS tablespace .so after reorg i tried this command ALTER TABLESPACE TABLESPACE NAME REDUCE MAX but it is not working.It is showing error. It will work for db29.5 versions...

hi all

I want to reduce the DMS tablespace .so after reorg i tried this command

ALTER TABLESPACE TABLESPACE NAME REDUCE MAX 

but it is not working.It is showing error.

It will work for db29.5 versions.

ALTER TABLESPACE <tsname> LOWER HIGH WATER MARK --+----------+-- 

If any other command i could use .please let me know.

Thanks

Deepshikha

Unanswered 227 1 / Create an account to join the discussion.
Mohan Prasath
Follow / 19 Jul 2017 at 8:36am / Toad for IBM DB2
Latest post by on 20 Jul 2017 at 1:41am

Need to get all Currency codes for a given Merchant ID from a DB2...

Expand content
I have a DB2 table TBL1. It has Merchant ID(MRCHNT_ID) and Currency_Code and few other columns. My requirement is for every Merchant Id, I need its list of Currency codes. Ex: MRCHNT CURRENCY ID CODE ...

    I have a DB2 table TBL1. It has Merchant ID(MRCHNT_ID) and Currency_Code and few other columns. My requirement is for every Merchant Id, I need its list of Currency codes. Ex:
    
    MRCHNT     CURRENCY
      ID         CODE   
    ---------  --------
    001812310  036      
    001812310  124      
    001812310  554      
    001812310  826      
    001812310  840      
    001812310  978
    
    So for this I need to get the resultant as:
    
    MRCHNT     CURRENCY CURRENCY  CURRENCY
      ID         CODE1   CODE2      CODE3
    ---------  -------- -------- -------- and etc..
    001812310  036      124         554
    
    I am getting this below resultant:

     MRCHNT                                                         
       ID       COL1  COL2  COL3  COL4  COL5  COL6  COL7  COL8  COL9
     ---------  ----  ----  ----  ----  ----  ----  ----  ----  ----
     001812310                                                  USD
     001812310                                            GBP       
     001812310                                NZD                   
     001812310              EUR                                     
     001812310        CAD                                           
     001812310  AUD

    When I run this query:
    
    SELECT DISTINCT(MRCHNT_ID),
    CAST(DECODE(A.CURRENCY_CODE,'036','AUD',' ')AS CHAR(3)),
    CAST(DECODE(A.CURRENCY_CODE,'124','CAD',' ')AS CHAR(3)),
    CAST(DECODE(A.CURRENCY_CODE,'978','EUR',' ')AS CHAR(3)),
    CAST(DECODE(A.CURRENCY_CODE,'344','HKD',' ')AS CHAR(3)),
    CAST(DECODE(A.CURRENCY_CODE,'392','JPY',' ')AS CHAR(3)),
    CAST(DECODE(A.CURRENCY_CODE,'554','NZD',' ')AS CHAR(3)),
    CAST(DECODE(A.CURRENCY_CODE,'702','SGD',' ')AS CHAR(3)),
    CAST(DECODE(A.CURRENCY_CODE,'826','GBP',' ')AS CHAR(3)),
    CAST(DECODE(A.CURRENCY_CODE,'840','USD',' ')AS CHAR(3))     
    FROM FX.FX_ACCOUNT A
    WHERE A.MRCHNT_ID = 001812310
    GROUP BY CURRENCY_CODE, MRCHNT_ID
    WITH UR;
    Need your expertise advice to get the resultant in the below format

    MRCHNT     CURRENCY CURRENCY  CURRENCY
      ID         CODE1   CODE2      CODE3
    ---------  -------- -------- -------- and etc..
    001812310  036      124         554

    Thanks in advance !!!

Answered 148 2 / Create an account to join the discussion.
Mimi_Alvarez
Follow / 5 Apr 2017 at 4:32pm / Toad for IBM DB2
Latest post by on 19 Jul 2017 at 7:36pm

Toad Automation Scripts

Expand content
I inherited about 20 queries that have to be run every day in Toad (version 6.1.0.134) for DB2 on z/OS and we manually email the results to various business users. Most of the queries have a date parameter...

I inherited about 20 queries that have to be run every day in Toad (version 6.1.0.134) for DB2 on z/OS and we manually email the results to various business users.  Most of the queries have a date parameter we update every day before running.

I'm trying to use Toad automation scripts to automate this process.  I plan to make each of the 20 queries into separate Toad automation scripts.  I'd like to have a "master" automation script that would prompt me for the needed dates, then it would call each of the 20 and pass them the dates provided.

I've run into several problems, so I'm starting to wonder if what I'm trying to do is possible or feasible?  Does anyone out there use Toad Automation Scripts and if so have you done anything like this, or do you have any suggestions or tips?

Thanks for any advice.

261 1 / Create an account to join the discussion.
ipeleva
Follow / 8 Jun 2017 at 7:24pm / Toad for IBM DB2
Latest post by on 20 Jun 2017 at 1:13pm

delete 1st line of text file in an automated job

Expand content
Hello, I have created a procedure to extract and update a table. I added the Procedure into a job , and the next step is to extract the data from that table into a text file with pipe delimited fields...

Hello,

I have created a procedure to extract and update a table.  I added the Procedure into a job , and the next step is to extract the data from that table into a text file with pipe delimited fields. What I cant find is how to delete the 1st line of the text file. 

example:

line1: 1
line2: 14466869-99999-2|1|

Thank you !

207 1 / Create an account to join the discussion.
nadendla.sudheer
Follow / 21 Nov 2016 at 3:46pm / Toad for IBM DB2
Latest post by on 15 Jun 2017 at 10:58pm

I was not able to connect to the db2 databases using Toad for DB2...

Expand content
Hi Team, I have installed Toad for DB2 Freeware 6.0 in one of our VM windows box and installed db2client and catalogued the databases. I could see those catalogued databases in Toad for DB2 window...

Hi Team,

 I have installed Toad for DB2 Freeware 6.0 in one of our VM windows box and installed db2client and catalogued the databases.

I could see those catalogued databases in Toad for DB2 window but when I was trying to connect I am getting the following error.

Could anyone please help me to check and suggest me what could be the issue.

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()

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

**********************************************************************
NOTE: We are eliminating automatic support case creation by email. Before sending your Support Bundle, ensure your subject line includes an opened CaseID:### or a Service Request ID:###. Without the CaseID or Service Request ID your Support Bundle request will be declined.

The quickest way to open a new service request is through our online Support Portal support.software.dell.com/Manage-Service-Request.

You can also contact Support for assistance to create a new case, please visit support.software.dell.com/.../contact-technical-support. Post case creation you will continue to have all communication options available including email, phone, or through the Support Portal to manage the lifecycle of your case.


**********************************************************************
Support Bundle: Toad for DB2 6.0.0.373 Freeware
11/14/2016 12:53:52 PM
**********************************************************************

**********************************************************************
System Information
**********************************************************************
Operating System
Microsoft Windows Server 2012 R2 Datacenter 6.3.9600 AMD64
Manufacturer: Microsoft Corporation
Computer Name: WHSE-WKSTN-DEV
Windows Directory: C:\Windows

Computer System
Computer Manufacturer Name: Microsoft Corporation
Computer Model: Virtual Machine
System Type: x64-based PC
Total Physical Memory: 7,339,572 KB
Domain: WORKGROUP
User Name:

System Processor
Manufacturer: GenuineIntel
Computer Processor: Intel64 Family 6 Model 63 Stepping 2
CPU Speed: 2.397 GHz
**********************************************************************
Connection Information
**********************************************************************
No open connections.

DB2 Client:
DB2 Client Type:
**********************************************************************
Loaded Assemblies
**********************************************************************
Accessibility, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Accessibility\v4.0_4.0.0.0__b03f5f7f11d50a3a\Accessibility.dll
ActiproSoftware.Docking.WinForms, Version=12.1.302.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.Docking.WinForms\12.1.302.0__c27e062d3c1a4763\ActiproSoftware.Docking.WinForms.dll
ActiproSoftware.Shared.WinForms, Version=12.1.302.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.Shared.WinForms\12.1.302.0__c27e062d3c1a4763\ActiproSoftware.Shared.WinForms.dll
ActiproSoftware.SyntaxEditor.WinForms, Version=12.1.302.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.WinForms\12.1.302.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.WinForms.dll
Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null Location is not supported for given Assembly
BouncyCastle.Crypto, Version=1.7.4114.6375, Culture=neutral, PublicKeyToken=0e99375e54769942 C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\BouncyCastle.Crypto.dll
CustomMarshalers, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_32\CustomMarshalers\v4.0_4.0.0.0__b03f5f7f11d50a3a\CustomMarshalers.dll
Dell.FastETL, Version=7.2.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Dell.FastETL.dll
Dell.NamedPipeRPC, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Dell.NamedPipeRPC.dll
Dell.SecTech, Version=4.3.0.448, Culture=neutral, PublicKeyToken=99d4728064788932 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Dell.SecTech\v4.0_4.3.0.448__99d4728064788932\Dell.SecTech.dll
Dell.ToadCommunication, Version=7.0.10.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Dell.ToadCommunication.dll
Dell.ToadGeneral, Version=7.0.10.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Dell.ToadGeneral.dll
DevExpress.BonusSkins.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.BonusSkins.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.BonusSkins.v13.1.dll
DevExpress.Charts.v13.1.Core, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Charts.v13.1.Core\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.Charts.v13.1.Core.dll
DevExpress.Data.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Data.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.Data.v13.1.dll
DevExpress.Utils.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Utils.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.Utils.v13.1.dll
DevExpress.XtraBars.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraBars.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.XtraBars.v13.1.dll
DevExpress.XtraEditors.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraEditors.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.XtraEditors.v13.1.dll
DevExpress.XtraGrid.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraGrid.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.XtraGrid.v13.1.dll
DevExpress.XtraTreeList.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraTreeList.v13.1\v4.0_13.1.5.0__b88d1754d700e49a\DevExpress.XtraTreeList.v13.1.dll
FastData, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\FastData.dll
IBM.Data.DB2, Version=9.7.4.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208 C:\Program Files\IBM\SQLLIB\BIN\netf40_32\IBM.Data.DB2.dll
IBM.Data.DB2, Version=9.7.4.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208 C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\IBM.Data.DB2.dll
Interop.StdVCL, Version=4.0.0.0, Culture=neutral, PublicKeyToken=298428818506a441 C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\Interop.StdVCL.dll
ManagedQP5, Version=5.2.5.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\managedqp5.dll
Microsoft.Win32.TaskScheduler, Version=1.9.4.17032, Culture=neutral, PublicKeyToken=0d013ddd5178a2ae C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Microsoft.Win32.TaskScheduler.dll
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll
PresentationCore, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_32\PresentationCore\v4.0_4.0.0.0__31bf3856ad364e35\PresentationCore.dll
PresentationFramework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.dll
PresentationFramework.AeroLite, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework.AeroLite\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.AeroLite.dll
Quest.Compare.General.Sys, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\Quest.Compare.General.Sys.dll
Quest.Compare.General.SysInterfaces, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\Quest.Compare.General.SysInterfaces.dll
Quest.Compare.Schema.Common.PlInterfaces, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\Quest.Compare.Schema.Common.PlInterfaces.dll
Quest.Compare.Schema.DB2.DBModel, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\Quest.Compare.Schema.DB2.DBModel.dll
Quest.Data.DB2.Admin, Version=5.5.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\Quest.Data.DB2.Admin.dll
Quest.PersistentCache, Version=3.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Quest.PersistentCache.dll
Quest.Toad.Interop.AxSHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Quest.Toad.Interop.AxSHDocVw.dll
Quest.VersionControl, Version=1.1.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Quest.VersionControl.dll
QuestElevation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\QuestElevation.exe
SHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\SHDocVw.dll
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll
System.Data.DataSetExtensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Data.DataSetExtensions\v4.0_4.0.0.0__b77a5c561934e089\System.Data.DataSetExtensions.dll
System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Design\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Design.dll
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll
System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Management\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Management.dll
System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Numerics\v4.0_4.0.0.0__b77a5c561934e089\System.Numerics.dll
System.Runtime.Remoting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Remoting\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Remoting.dll
System.Runtime.Serialization.Formatters.Soap, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll
System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_32\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll
System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_32\System.Web\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.dll
System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll
System.Xaml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xaml\v4.0_4.0.0.0__b77a5c561934e089\System.Xaml.dll
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll
Toad, Version=7.4.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\toad.exe
ToadBlue2014, Version=13.1.5.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\ToadBlue2014.dll
ToadCore, Version=7.4.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\ToadCore.dll
ToadDB2, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\ToadDB2.dll
ToadDB2Provider, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\ToadDB2Provider.dll
ToadDB2Wrapper, Version=5.2.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\Plugins\DB2\ToadDB2Wrapper.dll
ToadGreen2014, Version=13.1.5.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\ToadGreen2014.dll
ToadPlugin, Version=6.0.0.373, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\ToadPlugin.dll
ToadTan2014, Version=13.1.5.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\ToadTan2014.dll
UIAutomationTypes, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\UIAutomationTypes\v4.0_4.0.0.0__31bf3856ad364e35\UIAutomationTypes.dll
WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\WindowsBase\v4.0_4.0.0.0__31bf3856ad364e35\WindowsBase.dll
WindowsFormsIntegration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\WindowsFormsIntegration\v4.0_4.0.0.0__31bf3856ad364e35\WindowsFormsIntegration.dll
QP5, Version=5.270.14245.40037, C:\Program Files (x86)\Dell\Toad for DB2 Freeware 6.0\qp5.dll
**********************************************************************
Licensing
**********************************************************************
Freeware

LUW Freeware

1682 15 / Create an account to join the discussion.
Db2Developer
Follow / 19 May 2017 at 7:40pm / Toad for IBM DB2
Latest post by on 5 Jun 2017 at 7:13pm

Add option to add drop statement in script window

Expand content
Hello, Currently when you open the script window it shows your create statement as well as your setting your schema and user name. I was wondering if you could add an option in the settings to add...

Hello,

Currently when you open the script window it shows your create statement as well as your setting your schema and user name.

I was wondering if you could add an option in the settings to add the drop statement before the create in the script window? 

Since z/OS does not really allow for alter of store procedures I think having an option to enable the script window to auto put drop statement would be handy since I always have to drop and re-create objects.

Thanks again!

Toad for DB2 Beta 6.3.0.57 (64 bit). Db2 for z/OS.

243 1 / Create an account to join the discussion.
Db2Developer
Follow / 18 May 2017 at 6:43pm / Toad for IBM DB2
Latest post by on 19 May 2017 at 4:36pm

Upload DDL to Mainframe Member?

Expand content
I would like to give another suggestion to TOAD. I don’t think this would be too hard to do. I recently discovered the feature z/OS Remote Script Execute Wizard (I believe only enabled with DBA...

I would like to give another suggestion to TOAD.

I don’t think this would be too hard to do.

I recently discovered the feature z/OS Remote Script Execute Wizard (I believe only enabled with DBA license key).  I have to say I wish I found this years ago! 

Once you go through the wizard you are able to either run the JCL or upload the JCL to a member on the mainframe.  I tried the upload and it works great.  I was wondering if there was a way to take a DDL and just upload it to a Mainframe member.  So for example I could right click on a procedure and go through a wizard and push it to the mainframe.  I think this would add great functionality that most would enjoy.  

 Thanks again for the great support!!!

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

240 1 / Create an account to join the discussion.
Jeff Podlasek
Follow / 24 Apr 2017 at 4:44pm / Toad for IBM DB2

New Toad DB2 v6.3.0.232 beta download is available

Expand content
We have just posted our Toad DB2 v6.3.0.232 beta drop. This 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...

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

This 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...

249 0 / Create an account to join the discussion.
tejpatil
Follow / 8 Mar 2017 at 1:10am / Toad for IBM DB2
Latest post by on 10 Apr 2017 at 4:48pm

Fetch FIRST 1 ROW ONLY IN SUBSELECT GIVES SYNTAX ERROR IN TOAD for...

Expand content
Hi Folks Toad complains as SYNTAX Error when you a FETCH FIRST 1 ROW ONLY in a subselect of a query. Does anybody know across this situation. Not sure if this is a bug in Toad version 6.2.0.315 for DB2...

Hi Folks

Toad complains as SYNTAX Error when you a FETCH FIRST 1 ROW ONLY in a subselect of a query. Does anybody know  across this situation. Not sure if this is a bug in Toad version 6.2.0.315 for DB2 zos.

Thanks.

365 1 / Create an account to join the discussion.
dkirby
Follow / 27 Mar 2017 at 9:38pm / Toad for IBM DB2
Latest post by on 6 Apr 2017 at 5:59pm

FTP EXPORT

Expand content
I am trying to upload a .csv to an FTP site. The customer requires the file have an extention of yyyymmddhhmm and they do not want the header information. I had origially set it up as a file script with...

I am trying to upload a .csv to an FTP site.   The customer requires the file have an extention of yyyymmddhhmm and they do not want the header information.   I had origially set it up as a file script with results.  i was able to upload the file with the proper extention, but there is no way that i can find to elimanate the header information.  If i use the to Export wizzard,  I can control the header, but i can not control the format of the date suffix.  it allows me to add it,  but not control the format.    Any ideas?

Thanks DJ

431 3 / Create an account to join the discussion.
Jeff Podlasek
Follow / 30 Mar 2017 at 4:37pm / Toad for IBM DB2

Toad for DB2 - v6.3 beta installer updated

Expand content
We have just posted our latest beta drop: Toad DB2 v6.3.0.57 (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...

We have just posted our latest beta drop: Toad DB2 v6.3.0.57   (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...

205 0 / Create an account to join the discussion.
trialdb2
Follow / 28 Mar 2017 at 8:54pm / Toad for IBM DB2
Latest post by on 28 Mar 2017 at 9:09pm

Licensing information directory

Expand content
hi, where does toad for db2 client saves it's licensing information. and file name of licensing key. Thanks in Advance! *** answered. C:\Users\\AppData\Local\{08439167- 4CA5- 48E9...

hi,

where does toad for db2 client saves it's licensing information.

and file name of licensing key.

Thanks in Advance!

*** answered.

C:\Users\\AppData\Local\{08439167- 4CA5- 48E9-A810- A3A7C0B80B06}\ProductLicenses.xml 

Unanswered 318 1 / Create an account to join the discussion.