For Response mapping

[Former Member]

select columnid

FROM tablename

WHERE column1 = 'Z' AND (column2 <> 'N' AND column2 <> 'M')

For above query response mapping...do i need to use action= SQL_QUERY ?.

or simple datatype is fine?.

[Former Member]

Hi Rahul

You Can do it by defining datatype.

Make the occurence of COL2 as 1 to unbounded and then in your mapping

duplicate the Target Subtree and map it to the corresponding values.

Just go thru this doc -http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Rehards

[prabhu_s2]

may this weblog will help you in configuring jdbc reciever.

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

and check the below blog for response mapping:

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step