Skip to Content
avatar image
Former Member

JDBC sender channel to call a stored procedure from mssql database

Hi Experts,

I have developed a scenario JDBC>>PI>>RFC. We have to fetch data from Mssql Database so they have created a view stored procedure to fetch the data. PI should post this data in ECC via RFC.

Now my query is how do i configure the sender communication channel processing parameters.

* Query SQL Statement - ??

What statement should i use to trigger the stored procedure.

* Update SQL Statemet - ??

Please suggest me on using the statements on how to fetch data from mssql database.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 14, 2017 at 07:35 AM

    Hi Shravan!

    As far as I remeber, Table-returning function should be created at DB side which returns the result as table.

    In sender JDBC adapter you use Select statement to query that procedure, something like:

    SELECT a, b from MyTableProc()

    Result table produced by stored procedure must contain columns you use in Select statement.

    Bad news is that you can't use any statements with data side effects while creating such type of functions in MS SQL Server. So you can't perform UPDATE operation, for example, inside this function.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 11, 2017 at 05:20 PM
    Add comment
    10|10000 characters needed characters exceeded