how to use dbtab external definition for Receiver

[former_member745782]

hello guru's,

i have a fast question.

I connect my PI 7.4 to SQL server DB

I load some DB table as external definition. I may use these structure just for Sender? (DB to PI)

Or It's possible use these external definition also for Receiver? I try to create a Data Type for Table Receiver Statement, but i cannot reuse the external definition inside.

So I would like know if i need create the Data Type , field by field

all suggestion will be appreciated

alex

[Harish · Accepted solution]

Hi Alex,

you can use the external definition at sender and receiver side. Why you want to create data type?

if you want to use the struture (XSD or WSDL) for data type you need to modify header part of structure manually.

Regards,

Harish

[former_member745782 · Accepted solution]

I want create the Data Type because for Receiver use i need creat a special statement like this:

<root>

  <StatementName1>

<dbTableName action="ACTION>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

so i cannot use the External Definition directly.

And my structure is not XSD or WSDL, but a dbtable and i cannot modify it.

[Former Member · Accepted solution]

Hello,

>>I may use these structure just for Sender?

Yes , you can use it.

>>Or It's possible use these external definition also for Receiver

Not possible, you have to create the receiver structure manually.

Thanks

Amit Srivastava

[former_member184720 · Accepted solution]

Yes..we have to create manually

In case you have too many fields and if this is a repetitive task may be you can refer to below

http://scn.sap.com/people/liang.ji/blog/2009/03/03/data-type-generator

It might help you as you can simply copy the fields from database table/xsd structure..

[former_member745782 · Accepted solution]

understand.

It's a pity we cannot use it for both directions.

Anyway thanks so much