Hello DBeaver Team
I have two problems by executing DB2 stored procedure
and I hope you can help me. I'm using DBeaver 3.4.1.
First problem:
There seems to be a problem of the input/output parameters.
If for example I execute this IBM stored procedure :
call sysproc.get_config(null,null,null,null,null,?,?)
I get a SQL -469 error (you can see it in the picture).
I tried different jdbc Drivers, but without any success.
If I execute the same statement in the db2 command window (clp) it works (you can see it in the next Picture).
I think the problem is that the parameter is defined as INOUT and not handled correctly.
Second problem:
DBeaver does not return the values of the output parameters, when a stored procedure is called.
For example I created this simple stored procedure:
CREATE OR REPLACE PROCEDURE
TEST.PROC( IN IN_DM char(2), OUT OUT_DM char(2))
SPECIFIC TEST.PROC
LANGUAGE SQL
NO EXTERNAL ACTION
DETERMINISTIC
BEGIN
SET OUT_DM = 'AB';
END;
If I execute "call TEST.PROC(null,?);" I get in DBeaver only the values of the Query and Updated Rows.
With db2cmd I also get the value of the output parameter. You can see the output in one of the pictures.
My last question is can you please change the input-mask of the stored-procedure parameter list.
For example if you call a stored-procedure with several ? as parameters,
you get a seperate window where you can fill out every parameter.
The problem is if you don't want to change anything of the parameters you have to hit several times
the OK button, because the cursor jumps from one input field to the next until the end.
I think it is better if the OK button means that you want to execute the stored procedure now.
You can already jump with TAB between the input fields.
Thank you very much
Best Regards