on 06-25-2015 7:15 PM
Hello All,
I am using SOAP to Receiver JDBC with backend as a View in SQL Server. The scenario is working fine. I am using SQL XML format on the receiver side.
Is there a way through PI that I can just ask for top 10 rows for the query without using Stored procedure. Its a basic select query with 3 KEY1 parameters.
Thanks,
Kiran
Kiran,
If I understand correctly, you want to create a new scenario (JDBC to SOAP). It is not related to already working interface (SOAP to JDBC).
To select top 10 records from JDBC, write a select statement in sender JDBC channel. I suggest to test the query directly on database using SQL client, first.
SELECT TOP 10 * FROM Customers where country = "Germany";
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Kiran,
It seems, it is synchronous scenario (SOAP <-> PI <-> JDBC).
Receiver JDBC channel supports XML form of
SELECT col1,col2 FROM dbTableName WHERE col2=’val2old’
Defining a SELECT Statement - SAP Library
To retrieve top 10 records:-
You can try Native XML format. Note:- actual text SQL statement should be sent to receiver JDBC channel.
SELECT TOP 10 * FROM Customers where country = "Germany";
Defining XML Documents for Message Protocol Native SQL Format
OR
You can request database team for stored procedure
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.