Example Receiver XMLSQL Structure

[Former Member]

Can anybody post Example Receiver XMLSQL Structure.

[Former Member]

the sample structure looks as follows:

<StatementName>

<dbTableName action="INSERT">

<access>

<ID>val1</ID>

<NAME>val2</NAME>

<Menge>val3</Menge>

<flag>val4</falg>

</access>

</db TableName>

<StatementName>

Where table name is the naem of the table, action can be

INSERT/DELETE/UPDATE/SELECT.If the message is sent synchronously for the above mentioned yo can receives the follwoing values .

Select : Resulset will be returned

Insert/Update/Delete : No. of rows affected.

Regards,

kiran.

[prateek]

Hi Rahul,

I think u wanted this

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Prateek

[Former Member]

Hi Rahul,

Check this similar thread and blog for some help:

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

Regards,

Subhasha Ranjan