DB2 stored procedure

[Former Member]

I need to call the DB2 stored procedure and make it as receiver how do design data type to make stored procedure as receiver.

Thank you.

[bhavesh_kantilal]

Hi,

Sriram has illustrated how to call a MaxDB Stored Procedure in this blog. The Dtatatype , Messagetype etc will be the same for Db2 as well.

Please look into the same for more info,

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

Regards

Bhavesh

[Former Member]

Hi,

Go thro this link for knowing the types required for receiver JDBC.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

This is the structure for StoredProcedure:

<StatementName5>

<storedProcedureName action=” EXECUTE”>

<table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName5>

Regards,

P.Venkat

[Former Member]

Sorry, I need to call the DB2 stored procedure and make it as receiver how do design data type and Message Mapping to make stored procedure as receiver.

Thank you.

[Former Member]

Hi ,

Check this link...

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Sekhar