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
Bom dia! Estou com uma NFe de inutilização que está com os seguintes status: SEFAZ - OK Inutilizada GRC - OK Inutilizada ECC - Não OK O problema é que a nota fiscal está como aguardando resposta, mas no monitor está como concluido já. Achei esse post [More]
Hi All, I created a cluster in weblogic 9.2 and two manged servers under that cluster through WLST scripts. I started Node manager through connecting WLST and now when i am starting the managed servers its giving the following error : wls:/Dist_3/ser [More]
Hi, We have one Execution plan loading all the BI Analytics module as of now. 1)Financials, 2)Procurement and Spend, 3)Supply Chain and Order Management and 4)EAM Issue is if  i go to Tools-->ETL Management-->Reset Data Sources  in DAC, it refreshes [More]
Using this code i could find the source code of a html page from a web server import java.io.*; import java.net.*; public class SourceViewer{ public static void main (String[] args) throws IOException{ System.out.print("Enter url of local for viewing [More]
we are planning oracle DB version from oracle 10.2.0.4 to 11.2.0.2 , we are doing in AIX BOX. Below is steps can some one clarify if something is missing. 1)Cold backup 2)Start the db and change it into no archivelog mode 3)shut db 4)start in Upgrade [More]
if located in events and then in two or more albums in iPhoto? I want to organize photos as I have been getting a message that the startup disc is full.How much free space do you have on your startup disk? It's recommended that a miminum of 10 GB be [More]
I just installed my new Epson R1900 Printer and it says that it is online and recognized but when I send something to print it comes up in the queue and then disappears and doesn't print. The printer isn't idle or anything like that though, it still [More]
if I can update, change or add to my iWeb from my laptop if I built the site on my home system. I'm shooting a documentary on my in-laws that are adopting two children from Africa. We just landed in Addis Ababa and I would like to continue the "blogg [More]
Hi! Every time I download a pdf file it becomes converted into another type of file format. When you try to open the document it says: file conversion Select the encoding that makes your document readable. Text encoding: Windows (default)       MS-DO [More]
Hi all For some reason my Info area is not seen in the "open query"window, in the BEx Anal. can some tell me how to fix this. Thanks kaviHi kavi I am not sure Is it Business content infoarea, for me also business content infoarea is not seen, bu [More]