Skip to Content
0
Former Member
Sep 06, 2012 at 08:57 AM

JDBC receiver - Structure for select statment

11 Views

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