Share via

Call DB2 Store procedure in SSRS with dynamic parameters

Hiran R 1 Reputation point
2021-02-23T05:29:20.777+00:00

Am using SSRS report builder and connecting with DB2 data base using ODBC.

Am able to execute DB 2 SP with static parameters successfully, but in my scenario i need to pass the parameters dynamically (change parameter value while executing the SP).

Am trying with below query

CALL SP_Name(?parametername)

But I see an error " An error occurred while executing the query. CLI9112E error in assignment. SQL STATE=22005".

Regards
Hiran

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,949 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,596 Reputation points
    2021-02-23T07:49:47.547+00:00

    Hi @Hiran R ，
    The source of the problem seems to come from DB2. I'm sorry I can't provide you with help in this regard
    Please check if your DB2 is setting correctly under the rules.
    https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/odbc/src/tpc/db2z_odbcspcoding.html
    If it is not resolved, I would suggest you go to the DB2 forum for advice from experts.
    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.