Did anyone experienced issues with Data Studio 3.1.1 where it is not showing the stored procedure parameters correctly /
I have a stored procedure with 10 parameters and DS 3.1.1 is showing only 4 of them while looking at the properties. SYSROUTINES show them correctly and I have run a trace on DS 3.1.1 to get the SQL statements issued to get the parameter list. Running them separately get me the results properly, but properties window in DS 3.1.1 is not showing it correctly.
SELECT PARMNAME, ROWTYPE, LOCATOR, SCALE, LENGTH, SUBTYPE, RTRIM(TYPESCHEMA) AS TYPESCHEMA, TYPENAME, CCSID, ENCODING_SCHEME FROM SYSIBM.SYSPARMS WHERE SCHEMA = 'XXXXX' AND SPECIFICNAME = 'XXXXXXXXXX' AND VERSION = 'V1' ORDER BY ORDINAL
Pinned topic Bug in Data Studio 3.1.1 - Stored Procedure Parameters are not showing
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-23T16:39:50Z at 2013-03-23T16:39:50Z by SystemAdmin
Re: Bug in Data Studio 3.1.1 - Stored Procedure Parameters are not showing2013-03-22T21:22:03ZThis is the accepted answer. This is the accepted answer.Does your stored procedure have a parameter with TIMESTAMP data type? If it does, you hit a known defect which was already fixed in Data Studio 3.2.
Can you download Data Studio 3.2 to check if the problem goes away? If the problem still exists, can you share the source of the stored procedure, or send us the source via IBM support for further investigation?
Re: Bug in Data Studio 3.1.1 - Stored Procedure Parameters are not showing2013-03-23T16:39:50ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK