Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC document format

Hi folks,

I m using JDBC adapter at the Receiver side, and i m using "XML SQL Format" as message protocol.

the document format looks like ;

<root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

</root>

My question is can't we have multiple <dbtableName> have same action but different values in <table>tag assuming i have three tables to perform UPDATE_INSERT on say like below...and map data from the Same Source message.

<root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName1</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName><dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName2</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName3</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

</root>

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question