JDBC receiver - Structure for select statment

[Former Member]

Hi All,

I am trying to design a synchronous interface. I need a structure which is equivalent to the following query

"select ORDER_ID, STAT from HDR where ORDER_ID in ('123','456')"

I tried with the below structure.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_Output xmlns:ns0="Namespace"><StatementName1><CV action="SQL_QUERY"><access>select ORDER_ID, STAT from HDR where ORDER_ID in (&apos;$ORDER_ID$&apos;)</access><Key><ORDER_ID>123</ORDER_ID><ORDER_ID>456</ORDER_ID></Key></CV></StatementName1></ns0:MT_Output>

But we are getting reponse for the first value only. Please tell me how to change this structure accordingly, so that i need to get response for all the values of the field ORDER_ID

Thanks

Dinesh M

[zameerf]

You have multiple key values for ORDER_ID.

I guess it is not possible to have multiple key values for same placeholder.

Refer the below thread which has the same question.

http://scn.sap.com/thread/1881453

[MichalKrawczyk]

Hi,

try select statement from this link:

http://help.sap.com/saphelp_nw70ehp2/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Michal Krawczyk