Toad World® Forums

Getting the error in TOAD for DB2 Free Version 6.4 while altering the Stored Procedure

Steps to reproduce:

  1. Right Click on the Procedure name and select Alter Procedure

  2. After that every time clicking on the SQL body produces the error again.


Exception Information


Exception: System.NullReferenceException
Message : Object reference not set to an instance of an object.
Stack Trace:
at Quest.Toad.DB2.Doe.Procedure.ProcedureForm.GetCreateScriptForBodyEditor(String bodyLocation)
at Quest.Toad.DB2.Doe.Procedure.ProcedureForm.SetBodyEditorHeaderText()
at Quest.Toad.DB2.Doe.Procedure.ProcedureForm.pgctlSqlBody_Enter(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnEnter(EventArgs e)
at System.Windows.Forms.Control.NotifyEnter()
at System.Windows.Forms.ContainerControl.UpdateFocusedControl()


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.quest.com/Manage-Service-Request.

You can also contact Support for assistance to create a new case, please visit support.quest.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.2.0.315 Freeware
3/16/2017 12:49:02 PM



System Information


Operating System
Microsoft Windows 7 Enterprise 6.1.7601 AMD64
Manufacturer: Microsoft Corporation
Computer Name: SW07WVL10LD0003
Windows Directory: C:\Windows

Computer System
Computer Manufacturer Name: VMware, Inc.
Computer Model: VMware Virtual Platform
System Type: x64-based PC
Total Physical Memory: 2,096,696 KB
Domain: TW.TWEIS.NET
User Name: DOMAIN0\xhkrishn

System Processor
Manufacturer: GenuineIntel
Computer Processor: Intel64 Family 6 Model 62 Stepping 4
CPU Speed: 2.6 GHz
L2 Cache Size: Unknown

System Bios
BIOS: PhoenixBIOS 4.0 Release 6.0
BIOS Version: INTEL - 6040000

System Time Zone
Time Zone: (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi

Video Controller
Name: VMware SVGA 3D
Processor: VMware Virtual SVGA 3D Graphics Adapter
Mode: 1366 x 768 x 4294967296 colors
Video Ram: 1,084,608 KB
PNP Device ID: PCI\VEN_15AD&DEV_0405&SUBSYS_040515AD&REV_00\3&2B8E0B4B&0&78
Status: OK

Environment Variables
DB2TEMPDIR = C:\PROGRAM FILES\IBM\SQLLIB
ViewClient_Mouse.SampleRate = 60
ALLUSERSPROFILE = C:\ProgramData
ViewClient_Broker_DNS_Name = EPW-APP000458.TW.TWEIS.NET
windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log
LOGONSERVER = \WBMSLASDCAMER01
LOCALAPPDATA = C:\Users\xhkrishn\AppData\Local
MQ_JAVA_INSTALL_PATH = C:\Program Files (x86)\IBM\WebSphere MQ\Java
MQ_JAVA_LIB_PATH = C:\Program Files (x86)\IBM\WebSphere MQ\Java\lib64;C:\Program Files (x86)\IBM\WebSphere MQ\Java\lib
ProgramData = C:\ProgramData
ViewClient_Keyboard.ScanCodeMode = 1
ViewClient_Keyboard.Language = 1033
lib = C:\PROGRAM FILES\IBM\SQLLIB\LIB;C:\Program Files\IBM\SQLLIB\LIB;C:\Program Files\IBM\SQLLIB\LIB;C:\Program Files (x86)\IBM\WebSphere MQ\tools\lib64
USERDNSDOMAIN = AMER.WARNERBROS.COM
ViewClient_Displays.SystemDpi = 96
include = C:\Program Files\IBM\SQLLIB\INCLUDE;C:\Program Files (x86)\IBM\WebSphere MQ\tools\c\include;C:\Program Files (x86)\IBM\WebSphere MQ\tools\cplus\include
ProgramW6432 = C:\Program Files
ViewClient_Broker_UserName = xhkrishn
ViewClient_Displays.Topology = {1366,768,0,0,32,1}
ViewClient_Keyboard.SubType = 0
ViewClient_MAC_Address = 00-05-9A-3C-7A-00
ViewClient_Broker_URL = desktopwest.timewarner.com:443
SystemDrive = C:
ViewClient_Broker_Remote_IP_Address = 10.115.192.10
DB2INSTANCE = DB2
OS = Windows_NT
PROCESSOR_ARCHITECTURE = x86
ViewClient_Keyboard.KeyDelayToRepeat = 1
DB2PATH = C:\PROGRAM FILES\IBM\SQLLIB
ViewClient_Type = Windows
AppsenseShare = \USW_EIS_NTPCFS1.tw.tweis.net\ctxprofiles\Folder Redirection\WB\xhkrishn
ViewClient_Keyboard.KeyRepeatRate = 31
MQ_JRE_PATH = C:\Program Files (x86)\IBM\WebSphere MQ\java\jre
MQFT_JAVA_LIB_PATH = C:\Program Files (x86)\IBM\WebSphere MQ\java\jre\lib
MQFT_JRE_BIN_PATH = C:\Program Files (x86)\IBM\WebSphere MQ\java\jre\bin
CommonProgramW6432 = C:\Program Files\Common Files
ProgramFiles(x86) = C:\Program Files (x86)
USERPROFILE = C:\Users\xhkrishn
FP_NO_HOST_CHECK = NO
PUBLIC = C:\Users\Public
USERNAME = xhkrishn
ViewClient_Broker_Tunneled = true
windows_tracing_flags = 3
CommonProgramFiles = C:\Program Files (x86)\Common Files
ViewClient_Broker_DomainName = DOMAIN0
VS100COMNTOOLS = c:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\Tools
ViewClient_Keyboard.NumIndicators = 3
ViewClient_Mouse.Identifier = 2
ProgramFiles = C:\Program Files (x86)
PSModulePath = C:\Windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files\Microsoft Application Virtualization\Client
PROCESSOR_REVISION = 3e04
ViewClient_Launch_SessionType = DESKTOP
ViewClient_Machine_Domain = CORP
USERDOMAIN = DOMAIN0
ViewClient_Protocol = PCOIP
COMPUTERNAME = SW07WVL10LD0003
ViewClient_LoggedOn_Username = harikrik
CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
ViewClient_Mouse.NumButtons = 2
ViewClient_Windows_Timezone = India Standard Time
MQ_FILE_PATH = C:\Program Files (x86)\IBM\WebSphere MQ
SystemRoot = C:\Windows
HOMESHARE = \wb\capgemini\users\XHKRISHN
AppSenseHome = \USW_EIS_NTPCFS1.tw.tweis.net\ctxprofiles\Folder Redirection\WB\xhkrishn\AppSenseHome
ComSpec = C:\Windows\system32\cmd.exe
ViewClient_Keyboard.NumFuncKeys = 12
PROCESSOR_LEVEL = 6
ViewClient_IP_Address = 10.76.209.166
HOMEDRIVE = Z:
ViewClient_Machine_Name = LIN35001176
PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
MQ_JAVA_DATA_PATH = C:\Program Files (x86)\IBM\WebSphere MQ
ViewClient_Keyboard.Type = 7
PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 62 Stepping 4, GenuineIntel
Path = C:\PROGRAM FILES\IBM\SQLLIB\BIN;C:\PROGRAM FILES\IBM\SQLLIB\FUNCTION;C:\ProgramData\App-V\11AE6597-1581-4D24-A984-12AC971C5A48\5A2A92A8-0BFD-453D-9388-5463F9E09551\Root;C:\oracle\product\10.2.0\client_1\bin;C:\Program Files (x86)\IBM\WebSphere MQ\Java\lib;C:\Program Files (x86)\IBM\WebSphere MQ\Java\lib64;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\IBM\WebSphere MQ\bin64;C:\Program Files (x86)\IBM\WebSphere MQ\bin;C:\Program Files (x86)\IBM\WebSphere MQ\tools\c\samples\bin;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn;c:\Program Files\Microsoft SQL Server\100\Tools\Binn;c:\Program Files\Microsoft SQL Server\100\DTS\Binn;C:\Program Files\TortoiseSVN\bin;C:\Program Files\Common Files\ThinPrint;C:\Program Files\AppSense\Application Manager\Agent\Plugins\EcaRulesEngine;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;Z:.
windir = C:\Windows
ViewClient_Keyboard.Layout = 00000409
ViewClient_TZID = Asia/Calcutta
SESSIONNAME = Console
TMP = C:\Users\xhkrishn\AppData\Local\Temp
ViewClient_Launch_ID = WB-ADM-JavaCC
APPDATA = C:\Users\xhkrishn\AppData\Roaming
ViewClient_Keyboard.NumKeys = 101
DB2NMP_STATIC_LATCH = 1
ViewClient_Broker_Tags = RSA
NUMBER_OF_PROCESSORS = 2
CLASSPATH = C:\Program Files\IBM\SQLLIB\java\db2java.zip;C:\Program Files\IBM\SQLLIB\java\db2jcc.jar;C:\Program Files\IBM\SQLLIB\java\sqlj.zip;C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\Program Files\IBM\SQLLIB\bin;C:\Program Files\IBM\SQLLIB\java\common.jar;C:\Program Files (x86)\IBM\WebSphere MQ\Java\lib\com.ibm.mqjms.jar;C:\Program Files (x86)\IBM\WebSphere MQ\Java\lib\com.ibm.mq.jar;.
ViewClient_Language = en-US
HOMEPATH =
ViewClient_LoggedOn_Domainname = CORP
ViewClient_Displays.Number = 1
ViewClient_Broker_Tunnel_URL = desktopwest.timewarner.com:443
PROCESSOR_ARCHITEW6432 = AMD64
ViewClient_Displays.TopologyV2 = {1366,768,0,0,32,1,96}
TEMP = C:\Users\xhkrishn\AppData\Local\Temp
ViewClient_Client_ID = AgAAAM/H9BzLS6TYSDQm+1iqNhE=


Connection Information


Current Connection:
STARSDV1 (stars)
DB2 database [DB2/LINUXX8664]
Server version 10.1.3
Connected since 3/16/2017 12:20:50 PM
0 of 1 connection in pool active
Server Type: DB2/LINUXX8664
DB2 Client: 11.1.0.1527
DB2 Client Type: DB2 Run-Time Client
IBM DB2 Registry Info:
HKEY_LOCAL_MACHINE\SOFTWARE\IBM
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2
DB2 Path Name= C:\Program Files\IBM\SQLLIB
DB2 Folder Name=
DB2 Update Service Code= {B57F10E6-8A32-48F0-899C-70C6FD02ED7A}
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\COMPONENT
CLP=
CMD_NT=
INSTALL_COPY_SWITCHER=
CONFIG_MM=
DATA_PROVIDER=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\CurrentVersion
Modification= 300
Service Level= WR21392
Version= 9
Release= 1
Fix Level= 257
Default Language=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\DAS_PROFILES
=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\DB2 Run-Time Client
=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\DB2 Run-Time Client\CurrentVersion
Description= DB2 Run-Time Client
Last Modified Date= 3/2/2015
Modification= 300
Service Level= WR21392
Title= DB2 Run-Time Client
Version= 9
ProductCode= {3C06750E-F353-4F2A-9E62-B5EEE3F75D00}
Release= 1
Fix Level= 257
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\GLOBAL_PROFILE
DB2PATH= C:\Program Files\IBM\SQLLIB
DB2_EXTSECURITY= NO
DB2_COMMON_APP_DATA_PATH= C:\ProgramData
DB2SYSTEM= SW07WVL10LD0003
DB2INSTDEF= DB2
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstallData
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstallData\OLEDB
IBMDADB2= {67C0390E-CC7B-40D9-929E-48B484020C0B}
IBMDADB2 Connection Page= {515CB221-6DBF-485F-B0CF-F42D7EF10CC9}
IBMDADB2 Advanced Page= {76648011-3A6F-4258-85B9-346FEB6463E4}
IBMDADB2 Enumerator= {43990314-6B0F-4A86-9354-75FE72F90998}
IBMDADB2 Error Lookup= {23DF09EE-0A54-4EFA-891E-C42AA9459602}
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies
= DB2COPY1
defaultClientInterfaceCopy= DB2COPY1
11.1.0.DEF.2= DB2COPY1
11.1.0.DEF.4= DB2COPY1
11= DB2COPY1
11.1= DB2COPY1
11.1.0= DB2COPY1
11.1.0.1527= DB2COPY1
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\DB2COPY1
DB2 Folder Name=
DB2 Update Service Code= {B57F10E6-8A32-48F0-899C-70C6FD02ED7A}
DB2 Path Name= C:\Program Files\IBM\SQLLIB
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\DB2COPY1\CurrentVersion
Service Level= DYN1606081100WIN64
Fix Level= 1527
Default Language= en_US
Modification= 0
Release= 1
Version= 11
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\DB2COPY1\DAS_PROFILES
=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\DB2COPY1\GLOBAL_PROFILE
DB2PATH= C:\Program Files\IBM\SQLLIB
DB2_EXTSECURITY= NO
DB2_COMMON_APP_DATA_PATH= C:\ProgramData
DB2SYSTEM= SW07WVL10LD0003
DB2INSTDEF= DB2
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\DB2COPY1\InstallData
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\DB2COPY1\InstallData\OLEDB
IBMDADB2= {28C793F6-D390-468A-8339-8C492B721FCA}
IBMDADB2 Error Lookup= {BCED6EF9-ED73-40F1-9F35-0E166929B8ED}
IBMDADB2 Enumerator= {2F3D8AE7-5BAA-40CF-861F-574CD695C3D5}
IBMDADB2 Connection Page= {DDE4EF47-2560-4972-932E-BCE41F6474B1}
IBMDADB2 Advanced Page= {471F6AF0-74C3-4E3A-86C1-166671CC3C60}
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\DB2COPY1\PROFILES
=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\DB2COPY1\PROFILES\DB2
DB2INSTPROF= C:\ProgramData\IBM\DB2\DB2COPY1
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\ToadF40
DB2 Path Name= C:\Program Files (x86)\Quest Software\Toad for DB2 Freeware 4.0\DB2 Client
DB2 Folder Name=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\ToadF40\COMPONENT
CLP=
CMD_NT=
INSTALL_COPY_SWITCHER=
CONFIG_MM=
DATA_PROVIDER=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\ToadF40\CurrentVersion
Modification= 300
Service Level= WR21392
Version= 9
Release= 1
Fix Level= 257
Default Language=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\ToadF40\DAS_PROFILES
=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\ToadF40\DB2 Run-Time Client
=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\ToadF40\DB2 Run-Time Client\CurrentVersion
Description= DB2 Run-Time Client
Last Modified Date= 3/2/2015
Modification= 300
Service Level= WR21392
Title= DB2 Run-Time Client
Version= 9
ProductCode= {3C06750E-F353-4F2A-9E62-B5EEE3F75D00}
Release= 1
Fix Level= 257
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\ToadF40\GLOBAL_PROFILE
DB2PATH= C:\Program Files (x86)\Quest Software\Toad for DB2 Freeware 4.0\DB2 Client
DB2INSTDEF= TOADF40
DB2_EXTSECURITY= NO
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\ToadF40\InstallData
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\ToadF40\InstallData\OLEDB
IBMDADB2= {67C0390E-CC7B-40D9-929E-48B484020C0B}
IBMDADB2 Connection Page= {515CB221-6DBF-485F-B0CF-F42D7EF10CC9}
IBMDADB2 Advanced Page= {76648011-3A6F-4258-85B9-346FEB6463E4}
IBMDADB2 Enumerator= {43990314-6B0F-4A86-9354-75FE72F90998}
IBMDADB2 Error Lookup= {23DF09EE-0A54-4EFA-891E-C42AA9459602}
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\ToadF40\PROFILES
=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies\ToadF40\PROFILES\TOADF40
DB2INSTPROF= C:\PROGRA~2\QUESTS~1\TOADFO~1.0\DB2CLI~1
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\ProductData
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\ProductData{3C06750E-F353-4F2A-9E62-B5EEE3F75D00}
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\ProductData{3C06750E-F353-4F2A-9E62-B5EEE3F75D00}\PersistentProperties
DB2_COPY_NAME= ToadF40
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\PROFILES
=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\PROFILES\DB2
DB2INSTPROF= C:\ProgramData\IBM\DB2\DB2COPY1
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\GSK7
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\GSK7\CurrentVersion
Version= 7.0.4.23
InstallPath= C:\Program Files (x86)\ibm\gsk7
LibPath= C:\Program Files (x86)\ibm\gsk7\lib
BinPath= C:\Program Files (x86)\ibm\gsk7\bin
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\GSK7\CurrentVersion\REGAPPS
AMQWMQ70= Registered
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\GSK7\CurrentVersion\Uninstall
UninstallFile= C:\Program Files (x86)\ibm\gsk7\gsk7BUI.isu
UninstallExe= C:\Windows\gsk7BUI.exe
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\Installation Manager
location= C:\Program Files\IBM\Installation Manager
version= 1.7.2
internalVersion= 1.7.2000.20140227_0303
launcher= C:\Program Files\IBM\Installation Manager\eclipse\IBMIM.exe
appDataLocation= C:\ProgramData\IBM\Installation Manager
is64bit= true
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\License Use Runtime
I4DRIVER= System.Byte[]
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\MQSeries
=
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\MQSeries\CurrentVersion
GSKitPath64= C:\Program Files (x86)\IBM\GSK7_64
GSKitPackaged= GSK7
GSKitJREPath= C:\Program Files (x86)\IBM\WebSphere MQ\gskit\jre
WorkPath= C:\Program Files (x86)\IBM\WebSphere MQ
FilePath= C:\Program Files (x86)\IBM\WebSphere MQ
LanguageCode= a
Migrated= 0
BuildDate= Packaged on Aug 13 2009 at 00:00; version 1.11
PackageCode= {3EAC6009-7144-45CA-9BB1-6AD35FD87D39}
ProductCode= {3ED097FB-D882-4338-BD05-7D750F46C3E5}
UpgradeCode= {8D1C5EA1-A4C5-4967-97FA-77FE6D4B5EA7}
LicenseType= prod
BuildTime= 128945952000000000
VRMF= 7.0.1.0
SSLConnections= 0
ProgramFolder= IBM WebSphere MQ
MQServerVersion= 7
MQServerRelease= 0
PTFComponent= U200000
Language= English
=
Package= Server
ProductType= Server
GSKitPath= C:\Program Files (x86)\ibm\gsk7
WorkbenchPath= C:\Program Files (x86)\IBM\WebSphere MQ\eclipseSDK33
CreatedAccount= 1
ServicesInitialised= 1
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\MQSeries\CurrentVersion\Components
JavaMsg= Installed
Server= Installed
Development Toolkit= Installed
=
Explorer= Installed
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\MQSeries\CurrentVersion\Configuration
&