on 09-20-2011 4:05 PM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
<IRRELEVANT LINK>
Regards,
Naveen
Edited by: Prateek Raj Srivastava on Sep 24, 2011 12:49 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.