Some SELECT statements in Synchronous Send Step. Is it possible?

[Former Member]

Hello,

I need to send <b>synchronous</b> query to DB:

I want to set two SELECT statement in query:

<root>

<StatementName1>

<anyName action=” SQL_QUERY”>

<access>SQL-String </access>

</anyName >

</StatementName1>

<StatementName2>

<anyName action=” SQL_QUERY”>

<access>SQL-String </access>

</anyName >

</StatementName2>

</root>

Is it possible??

If it is possible HOW I should construct a correct response message type?? How does it look like?

I need to put the results of two SELECT in different structures of response message!!

Thanks

[prabhu_s2 · Accepted solution]

i think it is can be worked out. but for this u need to create two message type for request having the structre as per ur post and 2 message type for reposnse. In message mapping have the MT for request added and do the mapping and in the reponse tab have the both response MT added and map the fields accordginly to the targt MT.

[Former Member · Accepted solution]

Thanks Prabhu S!

As I understand you I need two request structure (Req1 and Req2 - for example) and two response structure accordingly (Res1 and Res2)?

You mean XI will map Req1 -> Res1 and Req2->Res2 without additional configuration steps?

[prabhu_s2 · Accepted solution]

refer this link for response mapping:

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3928. [original link is broken] [original link is broken] [original link is broken]

u dont require any config for response. just the mapping