on 08-28-2013 11:30 PM
Hi,
In a SAP PI 7.31, I have to configure a JDBC integration scenario JDBC -> PI -> AbapProxy. The BD is SQL Server 2008. Can be set in the sender JDBC Adapter in the field SQL Query Statement calling a Stored Procedure and returns two or more tables, for example DocsHeader, DocsPosition, DocsAditionals.
If supported, as in the example of Stored Procedure call and receiving XML tables.
Regards,
Johnny Muñoz
Hi Jhonny,
As far as i know there isn't any incompatibility to use a stored procedure in jdbc sender with SQL server.
By SAP documentation:
○ Specify an SQL EXECUTE statement to execute a stored procedure, which contains exactly one SELECT statement.
I think you could do a DB view which contains the three tables.
One example that deal about the XML obtained with the jdbc sender:
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.