ABAP Proxy TO DB2 (Stored Procedure)

[Former Member]

Hi all,

I am sending ABAP Proxy to DB2 database.

<?xml version="1.0" encoding="utf-8" ?>

- <nr1:SD002_ZKTSD_SHIPT_Msg xmlns:nr1="http://amkor.com/SD">

<MANDT>300</MANDT>

<KUWE>300</KUWE>

<NAME1>300</NAME1>

<NAME2>300</NAME2>

<LKUNWE>300</LKUNWE>

<NAME_CO>300</NAME_CO>

<STRL1>300</STRL1>

<STRL2>300</STRL2>

<STREET>300</STREET>

<STRL3>300</STRL3>

<LOCATION>300</LOCATION>

<EXTENSION1>300</EXTENSION1>

<LAND1>300</LAND1>

<LANDX>300</LANDX>

<TEL_NUMBER>300</TEL_NUMBER>

<FAX_NUMBER>300</FAX_NUMBER>

<KUKLA>300</KUKLA>

<BAHNS>300</BAHNS>

<BAHNE>300</BAHNE>

<MONDAY>300</MONDAY>

<TUESDAY>300</TUESDAY>

<WEDNESDAY>300</WEDNESDAY>

<THURSDAY>300</THURSDAY>

<FRIDAY>300</FRIDAY>

<SATURDAY>300</SATURDAY>

<SUNDAY>300</SUNDAY>

<IF_DATE>300</IF_DATE>

<IF_TIME>300</IF_TIME>

<IF_STATUS>300</IF_STATUS>

<IF_ERRDESC>300</IF_ERRDESC>

<IF_USER>300</IF_USER>

</nr1:SD002_ZKTSD_SHIPT_Msg>

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:SD002_SDSHPTO_Msg xmlns:ns0="http://amkor.com/SD">

- <Statement>

- <SDSHPTO action="EXECUTE">

<table>SDSHPTO</table>

<P_SAPC isInput="true" type="CHAR" isOutput="true">300</P_SAPC>

<P_COMP_NAME1 isInput="true" type="CHAR" isOutput="true">300</P_COMP_NAME1>

<P_COMP_NAME2 isInput="true" type="CHAR" isOutput="true">300</P_COMP_NAME2>

<P_L_SHIPTO isInput="true" type="CAHR" isOutput="true">300</P_L_SHIPTO>

<P_ADDR1 isInput="true" type="CHAR" isOutput="true">300</P_ADDR1>

<P_ADDR2 isInput="true" type="CHAR" isOutput="true">300</P_ADDR2>

<P_ADDR3 isInput="true" type="CHAR" isOutput="true">300</P_ADDR3>

<P_ADDR4 isInput="true" type="CHAR" isOutput="true">300</P_ADDR4>

<P_ADDR5 isInput="true" type="CHAR" isOutput="true">300</P_ADDR5>

<P_ADDR6 isInput="true" type="CHAR" isOutput="true">300</P_ADDR6>

<P_ATTENTION isInput="true" type="CHAR" isOutput="true">300</P_ATTENTION>

<P_CNTY_SDES isInput="true" type="CHAR" isOutput="true">300</P_CNTY_SDES>

<P_CNTY_FDES isInput="true" type="CHAR" isOutput="true">300</P_CNTY_FDES>

<P_TELEPHONE isInput="true" type="CHAR" isOutput="true">300</P_TELEPHONE>

<P_FAX isInput="true" type="CHAR" isOutput="true">300</P_FAX>

<P_INTERCOMPANY isInput="true" type="CHAR" isOutput="true">300</P_INTERCOMPANY>

<P_INV_HEADER isInput="true" type="CHAR" isOutput="true">300</P_INV_HEADER>

<P_INV_DETAIL isInput="true" type="CHAR" isOutput="true">300</P_INV_DETAIL>

<P_MONDAY isInput="true" type="CHAR" isOutput="true">300</P_MONDAY>

<P_TUESDAY isInput="true" type="CHAR" isOutput="true">300</P_TUESDAY>

<P_WEDNESDAY isInput="true" type="CHAR" isOutput="true">300</P_WEDNESDAY>

<P_THURSDAY isInput="true" type="CHAR" isOutput="true">300</P_THURSDAY>

<P_FRIDAY isInput="true" type="CHAR" isOutput="true">300</P_FRIDAY>

<P_SATURDAY isInput="true" type="CHAR" isOutput="true">300</P_SATURDAY>

<P_SUNDAY isInput="true" type="CHAR" isOutput="true">300</P_SUNDAY>

<P_IFDATE isInput="true" type="CHAR" isOutput="true">300</P_IFDATE>

<P_IFTIME isInput="true" type="CHAR" isOutput="true">300</P_IFTIME>

<P_IFSTATUS isInput="true" type="CHAR" isOutput="true">300</P_IFSTATUS>

<P_IFDESC isInput="true" type="CHAR" isOutput="true">300</P_IFDESC>

<P_IFUSER isInput="true" type="CHAR" isOutput="true">300</P_IFUSER>

</SDSHPTO>

</Statement>

</ns0:SD002_SDSHPTO_Msg>

I am getting the following error:

Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SDSHPTO' (structure 'Statement'): java.sql.SQLException: [SQL0204] SDSHPTO in type *N not found.

2007-01-12 09:50:22

Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SDSHPTO' (structure 'Statement'): java.sql.SQLException: [SQL0204] SDSHPTO in type *N not found.. Setting message to status failed.

Can anyone tell me the reason for the error?

Thank you

[prabhu_s2]

Dear chang

When you want to update a DB the structure of the tartget node shud satisfy few criterias. For example it should have the doc structure:

<root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

Also follow this link for more clarification:

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm">http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm</a>

PS: Award points for helpful replies

Regards

Prabhu

[Former Member]

Hi,

I think there is some undefined object in the table. Check for that.

Regards,

P.Venkat

[Former Member]

its not able to find out SDSHPTO table. Please make sure its available and path/schema is correct. Did you install JDBC drivers for DB2?

--Archana

[Former Member]

Hi,

Please check the name of the database table, check the case of the name also.

Regards Nagesh.