Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as program error.
Error description
Problem Description: The problem is that Visual Studio 2005 dataset wizard is creating the stored procedures parameters in wrong order and also all parameters are defined as Object dbType instead of the appropriate type. Problem Details: When working with DB2 and Visual Studio.Net. DB2 with Websphere Federation Sever version 9.1 fixpack 2 on Windows. Using this VS wizard when we call a stored procedure(Existing SP), there are two problems. 1-The datatype attribute of the stored procedure parameters just says 'object' ,instead of the actual parameter type. 2-The order of the parameters is incorrect. Suppose i call a SP with parameters a,b,c in that order,and all are of different datatype,but when i see the parameter that are passed by VS Wizard(In the parameter collector editor) i see the parameters are being passed in a different order say b,c and a and the datatype being passed is object.instead of the actual datatype.
Local fix
1. Create a new datasource for the SP with parameters 2. Right click on the created datasource and select "Edit Data set with Designer" 3. Click on the 'Fill' method on the designer and check its properties in the Property Window 4. Click on drop down for the property Parameter with value as Collection 5. It launches the dialog "Parameter Collection Editor", which displays all parameters and proprties, select the actual datatype of the parameter and change the order of the parameters by Up/down arrow keys. 6. Click OK to save this setting
Problem summary
VISUAL STUDIO 2005 DATASET WIZARD CREATES THE STORED PROCEDURES PARAMETERS IN WRONG ORDER AND WITH WRONG DATATYPE.
Problem conclusion
First fixed in DB2 UDB Version 9.1 FixPak 5
Temporary fix
1. Create a new datasource for the SP with parameters 2. Right click on the created datasource and select "Edit Data set with Designer" 3. Click on the 'Fill' method on the designer and check its properties in the Property Window 4. Click on drop down for the property Parameter with value as Collection 5. It launches the dialog "Parameter Collection Editor", which displays all parameters and proprties, select the actual datatype of the parameter and change the order of the parameters by Up/down arrow keys. 6. Click OK to save this setting
Comments
APAR Information
APAR number
IZ09563
Reported component name
DB2 UDB ESE HP-
Reported component ID
5765F4103
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-11-28
Closed date
2008-07-02
Last modified date
2008-07-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 UDB ESE HP-
Fixed component ID
5765F4103
Applicable component levels
R910 PSY
UP
Document Information
Modified date:
02 July 2008