Skip to Content
0
Former Member
Feb 18, 2011 at 10:25 AM

How to use Native SQL statement in JDBC receiver interface

485 Views

Dear All,

Can any one please help us in using Native SQL statement in a JDBC receiver channel. The reason why I need to use Native SQL statement instead of standard XML structure is that I need to execute a dynamic SQL query in third party database system lke:-

"

Select Field1 Field2 from TABLE Where Field3 like "%Name'

"

I expect the the response in the form of XML file which I can pick up using synchornous interface as mentioned on help.sap.com:-

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

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

The value for %Name can change dynamically according to the transaction and hence cannot be inluded as a KEY element in standard XLM structure,

Hence I need to know:-

1. What message mapping I should use in case if I have to use Native SQL statement.

2.What operation mapping I should use in case if I have to use Native SQL statement.

If guess correclty I may have to use Java mapping to do the above activities. Hence I want to know

3 .How do to go about it to do the Java mapping.

Thanks

Ameet