Reg DB2 Stored procedure.

[Former Member]

Hi Experts,

Am trying out with DB2 synchronous scenario . Have done with the configuration everything is working fine. But in the response message from JDBC adapter am getting the no of records instead the output of the procedure.

CREATE PROCEDURE AXK14/POCPROC7

(IN i_EMPID CHARACTER(5),

IN i_EMPNAME CHARACTER(20),

IN i_DESG CHARACTER(20),

OUT EMPID CHARACTER(5),

OUT EMPNAME CHARACTER(20),

OUT DESG CHARACTER(20))

LANGUAGE SQL

INSERT INTO POCFILE (EMPID, EMPNAME, DESG, FLAG)

VALUES (i_EMPID, i_EMPNAME, i_DESG, 'Y');

Can anyone suggest whats the problem here.

[Former Member · Accepted solution]

Hi Prem,

Can you try to create the proc. like mentioned in this blog:

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Also you can see this for some info, but this doesnot give any response back.

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

Also try to execute the proc. at the database level first and see whether you are getting the result what you want.

Regards,

---Satish