calling store procedure of DB2 from SAP CPI.

[aswini_upadhyaya1]

Hello,

We are currently facing an issue while calling Stored Procedures on COBOL DB2 Server.

Below are the details of Stored Procedures

EXEC SQL

   CALL  RCI000.DCISA20  ( :IN-DATA  ,

                           :O-RC     ,

                           :O-SCODE  ,

                           :O-ABCODE ,

                           :O-CHKDGT )

END-EXEC.

This stored procedure(DCISA20) have 5 arguments,

Input argument is one( like IN-DATA ), and

Output arguments are four( like O-RC ,  O-SCODE, O-ABCODE, O-CHKDGT).

You should send input parameter in first argument, and you can get data from last 4 arguments.

The store procedure works for them in command prompt line, but the same is not working from SAP CPI

CALL RCI000.DCISA20( '123050XB253D  K45    01                                                                                          X JSP      ' , ? , ? , ? , ?);

Tried multiple options but no luck. Please let us know the way forward on how to execute DB2 COBOL Stored Procedure from SAP CPI.

Regards,

Ashwin