baztian/jaydebeapi

Call Procedure with output parameters on JDBC IBM DB2

DeltaFox0018 opened this issue · 1 comments

DeltaFox0018 commented

Hello,
I am using jaydebeapi via python
I created a procedure on AS400 with 2 input parameters and 1 output

CREATE PROCEDURE JRAPOBJ.JRI01SV1SP (
IN KJCUSE CHAR(10),
IN KJPASW CHAR(10) ,
OUT KJERRO CHAR(1))
LANGUAGE RPGLE
SPECIFIC JRAPOBJ.JRI01SV1SP
NOT DETERMINISTIC
NO SQL
CALLED ON
NULL INPUT
EXTERNAL NAME 'JRAPOBJ/JRI01SV1PY'
PARAMETER STYLE GENERAL WITH NULLS

from SQL if I run the call CALL JRAPOBJ.JRI01SV1SP(user, psw, ?)
I return as a result the variable KJERRO with S or N based on whether the login is successful or not
Via in JDBC driver if I call with cursor.execute() works but I can’t recover the output data

If I make a cursor print.arraysize I return 1 instead cursor.rowcount I return 0

How do I do that?
Thank you

9icon commented

Was looking for how to retrieve output parameters as well. Is this option now available?

  • 👍1