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
As soon as I open up safari, it doesn't even load, i just get a page that says it quit unexpectedly, then I get about 28 pages worth of error code. The code is: Process: Safari [402] Path: /Applications/Safari.app/Contents/MacOS/Safari Identifier: co [More]
I don't know why an artist's greatest hits album is put into the Compilations folder, and not the artist's folder. I'd rather all their songs be in one folder, including any greatest hits. I can't seem to find any way to fix this. If I move the album [More]
Is anyone using this combination with a projector??? I want to use it in my classroom but have noticed a few posts where people have mentioned the scaling is off. Please let me know if you are using the ipad mini/apple tv/projector combination and if [More]
Is there an app that would let me basically scroll through a folder with the pdfs, Pages, and/or saved email visible at actual size (8 1/2 x 11) or some other realistically sized almost full screen method? As I new user I absolutely /love/ Coverflow [More]
Ok, so I was working on wrapping the main program and the classes together and I come up with that error...TopSort.java:40: non-static method addVertex(java.lang.String) cannot be referenced from a static context. I know why I am getting the error, I [More]
Hello experts, Could  someone help me with a report which will list trade debtors in local and foreign currency.                                                                                The report will need to include: u2022     amount, u2022   [More]
hey Folks, I know u all must have faced this situation. We have OBIEE 11g x.x.x.x.6. we have around 1000 reports made. We have done some clean up in RPD in which we deleted few unused table/columns. 1) How do we test the impact whether no report brea [More]
with 1 click? Instead of clicking "download to" for each file. I have a page that will query a db with the user supplied variable and return several (10 or more) files on a page which displays the return values as links that launches the downloa [More]
Hi All I was reading the data from an oracle database table through jdbc and storing them in an ArrayList, since there were around 1000 records and performing the action by iterating through the arrayList But now the record count has gone up to 20000 [More]
Error when performing full backup, please help. Starting backup at 14-AUG-08 current log archived released channel: ch1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS == [More]