cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Receiver Adapter with Native SQL String

Former Member
0 Kudos

Hi experts

I need to use a JDBC Receiver Adapter with Message Protocol of Native SQL String, but I don´t understand how to create my data type for XML Document Format. I studied the following example from the SAP Library,

INSERT INTO tableName (column-name1, column-name2, column-name3) VALUES(u2018column-value1u2019, u2018column-value2u2019, u2018column-value3u2019)

i´ll be very thankful of your recommendations.

Accepted Solutions (1)

Accepted Solutions (1)

stefan_grube
Active Contributor
0 Kudos

You have posted this question already and I have replayed on it.

If you do notunderstand my earlier response, tell me what you do not understand.

When you just ignore my response and repeat the question, I have the impression that it is a waste of time answering you.

Former Member
0 Kudos

Sorry, my first question was badly put, so a second post,

thanks for your help.

regards

prateek
Active Contributor
0 Kudos

Creating duplicate post is inappropriate and therefore I am locking this thread. You may copy content from here and post in original thread.

Regards,

Prateek Raj Srivastava

Answers (3)

Answers (3)

baskar_gopalakrishnan2
Active Contributor
0 Kudos

Another simple way is..

Create receiver data structure like this....

<StatementName>
<anyName action=u201DSQL_DMLu201D>
<access>INSERT INTO tableName (column-name1, column-name2, column-name3) VALUES('$column-value1$', '$column-value2$', '$column-value3$')
</access>
<key>
  <column-value1>value1</column-value1>
  <column-value2>value2<column-value2>
   <column-value3>value3<column-value3>
 </key>
 </anyName >  
 </StatementName>

Rest are all same.

naveen_chichili
Active Contributor
0 Kudos

Hi,

<IRRELEVANT LINK>

Regards,

Naveen

Edited by: Prateek Raj Srivastava on Sep 24, 2011 12:49 PM

Former Member
0 Kudos

Hi,

You can follow this document, to create the receiver Message protocol:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

This for JDBC Receiver Channel configuration:

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm