on 08-25-2010 9:58 PM
Hi All,
I am talking about Client Proxy to Receiver JDBC scenario.I've a requirement where i need to count the no of records created or updated in SQL server for particular transaction date.Question is- Is it possible to execute normal sql query to get the count or I need to write a stored procedure in SQL Server to be used by JDBC adapter.Please suggest with an example if possible.
thanks for the help
Hi,
if you just need to know about the no of records inserted using the jdbc receiver adapter then the communication channel logs which shows the same...
if you need to return back the no of records inserted into the jdbc then need to look for stored procedures for the same..
HTH
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Refer to the below link:
http://help.sap.com/saphelp_nwpi711/helpdata/en/43/9519abb1146353e10000000a11466f/frameset.htm
For how to use Stored procedure in PI.
Thanks,
Hetal
Hi.
Pls check this link.
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm
action= EXECUTE
Edited by: Luis Ortiz on Aug 26, 2010 2:27 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you clarify bit more?
If it is from Proxy to JDBC, then do you want to insert data in Database coming from proxy and after that count records or something?
If it is from JDBC to Proxy, then i think you should be able to do it with normal query to count number of records.
Thanks,
Hetal
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 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.