How to run DB2 Stored Procedure - facing issue while using run query

Help Studio
, ,
1

Hello,

I have setup the ODBC connection for DB2 database,

while I am using the Run Query command,

SQL command: “exec CIMT.dbo.RECSSP09”

I am getting an error, please help

Run query - Inquiries: ERROR [42601] [IBM][CLI Driver][DB2] SQL0104N An unexpected token “EXEC” was found following “”. Expected tokens may include: “<ERR_STMT> <WNG_STMT> TRANSFER GET SQL SAVEPOINT HOLD FREE”. SQLSTATE=42601

2

@Ranveer_S_Thakur

can you use this command

CALL CIMT.dbo.RECSSP09
2 Likes
3

Thank you @muktadir!

But how to pass the parameters, I passed it in properties panel.
But I did not get the expected results, it returns It is returning Proc Status as 3 and zero records