External definition of type "dbtab" and jdbc sender/receiver scenarios

[former_member188019]

Hi

As per this blog "SAP PI 7.1 Mapping Enhancements Series: Import SQL Table's Metadata" /people/william.li/blog/2008/01/02/sap-pi-71-mapping-enhancements-series-import-sql-tables-metadata,

I think its a new functionality in PI 7.1;

It is possible to import the xsd corresponding to the table structure in the database.

After i imported, i can see a resutset element containing row element that inturn contains columnNames.

a sample xml corresponding to the imported xsd could be:

<ns0:USER_MASTER.resultSet xmlns:ns0="urn:sap.com:jdbcAdapter">
   <row>
      <column_name1>value1</column_name1>
      <column_name2>value2</column_name2>
      <column_name3>value3</column_name3>
   </row>
</ns0:USER_MASTER.resultSet>

When we import the database structure like this in the form of external definition,

can we use this only for jdbc sender, that too having only for select queries.

is it possible to use/reuse the imported structure for jdbc receiver.. e.g for the canonical xml format of the insert or update queries.

[Shabarish_Nair · Accepted solution]

this is only helpful for the Sender JDBC structure so as you have mentioned Select statements can find its worth here.