JDBC Receiver Adapter Sum Query

[former_member186851]

Dear Scn Users,

Is there possibility of using Select sum query in JDBC Receiver??

I am able to successfully fetch data using Select query,let me know if there is any way to execute select sum query.

[iaki_vila · Accepted solution]

Hi Raghuraman,

Have you tried with the Action "SQL_QUERY" (Document Formats for the Receiver JDBC Adapter - SAP XI: Runtime - SAP Library)?. I know it is a bit "rustic" but i doubt you can do with the SELECT XML format.

Regards.

[former_member186851 · Accepted solution]

Hello Inaki,

Thanks for the link.Solved the same using Stored procedure.