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.