Sitemap

Amicuk Programming Answers

ABAP Proxy TO DB2 (Stored Procedure)

2015-10-11   Views:0

Advertisement

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>

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

The replay answer
Advertisement
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

Go to See the other 5 answers

ABAP Proxy TO DB2 (Stored Procedure)

Category:DefaultRelease time:2015-10-11Views:130

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>[More]

To call db2 stored procedure having parameters in java application

Category:DefaultRelease time:2015-10-11Views:130

Hi, I've created db2 stored procedure which is running perfectly on db2 server after giving a CALL to it. But when I tried to call this same stored procedure in java application, its reflecting with following error...... com.ibm.db2.jcc.b.SqlExceptio[More]

Calling DB2 Stored procedure(with parameters) from powershell

Category:DefaultRelease time:2015-10-11Views:130

Hi  I am trying to call a DB2 stored procedure that has parameters from Powershell scrip and I am not able to can some one help me here? $ServerName = 'XXXX' $dbalias='XXXXX'  $conn_string = "Provider=IBMDADB2;DBALIAS=$dbalias;Uid=;Pwd=;"  $conn[More]

DB2 Stored Procedure from Java-JDBC

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am using DB2 stored procedure which have been written in COBOL. I have two types of stored procedures. First types of stored procedure takes IN parameter and returns OUT parameter. These stored procedures are working fine. The second type o[More]

Intergration with DB2 stored procedure

Category:DefaultRelease time:-0001-11-30Views:130

I am using Database adapter to integrate with DB2(version 8) to call a stored procedure,however i receive a message "The adapter configurationwizard doesnot support DB2 stored procedures." I am using Jdeveloper 11g.Is there any work around or an[More]

Calling db2 stored procedures from wls 8.1 sp2

Category:DefaultRelease time:-0001-11-30Views:130

Hi, We noticed strange behaviour when moving customers applications from wls 6.1 to 8.1 sp2. We have a use case where we call db2 stored procedure two times (same prcedure) to make inserts to a database. The first time when procedure is called, every[More]

Calling DB2 Stored Procedures

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Following is my question. From Forte, How to call to a DB2 stored procedure which acceptsparameters?. If anybody knows the answer please mail me to [email protected] Thank U in Advance RamYou might want to look into the documentation for the Orac[More]

Converting DB2 stored procedure to Oracle?

Category:DefaultRelease time:-0001-11-30Views:130

I need a little help with a problem I ran across this week. I have an existing DB2 Stored procedure that calls a COBOL program. (See the procedure below). Now, I need to convert this DB2 to an Oracle Stored Procedure. I need the procedure to call the[More]

How do I call a DB2 Stored procedure?

Category:DefaultRelease time:-0001-11-30Views:130

I am having problems trying to call a DB2 stored procedure. I am using the Service: Foundation -> JDBC 1.0 -> Call Stored Procedure. Stored procedure I am calling is (with 4 input params): CALL DB2D.SYSPROC.REGC1389(?, ?, ?, ?, {$ /process_data/@Nam[More]

Resultset returns null while calling a DB2 stored procedure using hibernat

Category:DefaultRelease time:2015-10-11Views:130

Hi All , I am trying to call a db2 stored proc with cursor open from my java code but it always returns me null results though it executes fine when I call the procedure from the command line Java code.................... CallableStatement stmt3 = Ey[More]

Resultset returns null while calling a DB2 stored procedure using hibernate

Category:DefaultRelease time:2015-10-11Views:130

Hi All , I am trying to call a db2 stored proc with cursor open from my java code but it always returns me null results though it executes fine when I call the procedure from the command line Java code.................... CallableStatement stmt3 = Ey[More]

Hot
My printer is on and my print jobs spool but do not print.  Also Sometimes the printer is not recognised as being on.Hi KathyGates, Please let me take a moment to say "Welcome" to the HP Forums.   I hope you enjoy your experience! To help you ge [More]
ich möchte Adobe Photoshop CS3 bzw. Upgrade CS6 verkaufen wie?Ja, nur die Lizenz muss übertragen werden. Mehr hier: https://helpx.adobe.com/de/x-productkb/policy-pricing/transfer-product-license.htmlRead other 3 answers [More]
hi I want to purchase sap netweaver software. I have p4 computer at my home and what are the configuration of computer to install sap netweaver software. Can you help me to get sap netweaver software? Plz give me reliable or helpful information. I m [More]
I have a SC approval that errored out when coming back to SRM. We run RBBP_OFFLINE_EVAL program periodically throughout the day to pick up offline approvals from users. In the spool list, I see this message: Document Contains Errors. Approval is not [More]
Hello, as it says in the topic, i was wondering if it is possible to change the volume of the front and the back speakers (the same way it is possible to change the volume of the center speaker). If anyone could tell me wether this is possible at all [More]
When trying to shutdown a zone though SunMC it get the following error from the web page SNMP request returned error status 6 (no access) snmp://xx.xx.com:nnnn/mod/scm-container/Zones/ZoneTable/ZoneEntry/zoneState#zonename the log on the agent has [0 [More]
i'm currently looking for the data for travel management (Financials Management & Controling --> Travel Management) in the DS server. i have been looking for it for  a few week and i still cant get the data. so does anyone have any idea on where th [More]
i also had the same problem, but when i changed the %p , my parameter form still did not appear. Using reports 9i. ThanksThank You, that solved the problem. You can either use paramform=yes on the url, or in cgicmd.dat file, append %P on to the comma [More]
The local and remote layouts are created under the same name, but it appears that they are menu selected separately. I would have liked to have both activated together using the layout button via IR remote. Is this correct that the only way the remot [More]
Why do I get the message ''icloud encountered an error while trying to connect to the server'' from my Windows 7 PC?Does this happen in a new user profile.. and what version of windows 64 or 32 bit ?Read other 2 answers [More]