Using the imported SQL Meta-data in PI 7.1

[Former Member]

Hi Team,

We have successfully imported the SQL Table meta-data ( table structure ) in PI. However, we are unable to use the same structure below the 'access' node in the receiver JDBC structure.

Looking forward for your help.

Thank you,

Regards,

Rakesh.

[baskar_gopalakrishnan2]

Please elaborate more. Under access node you can specify all the table fields. Make sure specify the same way as that of table in the jdbc structure. For reference see the sap help document.

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

[Former Member]

Hi Baskar,

I do understand that we can specify the fields below access node...but there are 200 fields in that table and hence I have imported the fields ( using the import SQL metadata option in PI7.1) ...my question is how to use those 200 fields and attach them under the access node.

Please advise.

Thank you,

Regards,

Rakesh.

[baskar_gopalakrishnan2]

Do you need all the 200 fields value in your select query? If so you have to specify all of them under access node.

See below

<StatementName>

<dbTableName action=u201DSELECTu201D>

    <table>realDbTableName</table>

<access>  //note: specify below here all the 200 fields (if you need all of them here) if you need few then specify only those here.

<col1/>

<col2/>

<col3/>  

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>  

  </StatementName>

Another option is

<StatementName>

<anyName action=u201D SQL_QUERYu201D | u201CSQL_DMLu201D>

<access> Select A,B,C .... 200 from tablename where id='blah'</access>

<key>

  <placeholder1>value1</placeholder1>

  <placeholder2>value2<placeholder2>

</key>

 </anyName >  

  </StatementName6>