cancel
Showing results for 
Search instead for 
Did you mean: 

Receiver JDBC Adapter for Count of records in Table

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

I understand i have to for the stored procedure, but how to use store procedure in PI? could you please help on this.

thanks

Manish

Former Member
0 Kudos

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

Former Member
0 Kudos

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

former_member204873
Contributor
0 Kudos

Check this thread,it might be helpful:

Former Member
0 Kudos

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