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
Hi, Could anyone tell the difference Between Static and Dynamic Credit Check? According to website: http://www.sap-basis-abap.com/sd/difference-between-static-and-dynamic-credit-check.htm ... this is the answer: ==================== Simple Credit Che [More]
I have a 13" macbook air that has the following problem: I can connect to wifi networks (including at home WPA and also tried WPA2 settings) but even though I may get proper speed at first, I soon lose that and it becomes much slower and choppy (if I [More]
Hi Gurus, in sap crm 7.0 web ui i want to restrict particular user group to only" see" accounts it means only  "display"  view this we can achieve through status profile but how it is configured i don't know...can somebody help me unde [More]
Hellow Friends,      I want to get only TDS vendors list with Respective names.I have used Table LFBW.There i am getting only TDS Vendor codes list not comming with names. Is there any Table or T.Code or Report to get TDS Vendors list with names? Ple [More]
Hi guys, i created a SWF file based on the template available here http://www.adobe.com/devnet/flash/articles/vidtemplate_mediapreso_04.html Basically the movie has navigation buttons on the left side of the video display to enable users to jump to p [More]
Hi ,    When we do substitution in FICO by user exit there are three types of EXITS-PARAM     EXITS-PARAM = C_EXIT_PARAM_NONE.     EXITS-PARAM = C_EXIT_PARAM_FIELD     EXITS-PARAM = C_EXIT_PARAM_CLASS.    Could you tell me the difference among them? [More]
All, We are transferring quotations & orders from R/3 to CRM. Both of them have 'Z' transaction types and everything is working fine. But I have noticed in the SMW01 log that transaction types for warranties are also coming through to CRM(this has be [More]
Hello, I'm fairly new to Mac Mail and I've been having a few problems with it. First of all I've noticed a few times when I check my email it says I have more new messages than I actually have. An example today was the mail icon said I had 6 new mess [More]
Hi, We have assigned the customized Default Framework Page to the 'Everyone' group wherein we have removed the Page title bar Iview. So the users dont have the option of the 'History' and 'Back' buttons available on that iview. We dont want to make t [More]
When I make updates to my iWeb site, they cannot be seen unless I reset my browser.  It's become a mess; some clients think I haven't updated my site in 2 years!  Is there code I can embed in a snippet to force their browsers to reset?  TIAadding a q [More]