JDBC XML structure

[Former Member]

Hi,

I am new to XI. When I am using JDBC adpter as receiver we are using XML structue. In that we can maintain the table name in <realDBtablename > or <tablename> tag. What is the difference between these two tags. Which one we use in which scenario.If table having any special characters which tag we have to use? Please give detail information....

thaks

Sridhar

[Former Member · Accepted solution]

HI,

From SAP Help.

<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>

If you use the optional <table> element, the value specified is used as a database table name. This enables you, for example, to define table names containing non-XML-compatible characters or characters that prevent them from being used in interface definitions in the Integration Builder. If specified, <table> must be the first element in the block within <dbTableName>.

Regards,

Sudheer

[Former Member]

Hi Sridhar,

there ist no tag <realDbTableName>!!!

Have a closer look in

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

In Mapping replace <b>realDbTableName</b> with the name of the table you would like to select, insert, update!

Regards Mario